[Typo3-dev] Dates in non-UNIX format

[Martin T. Kutschker]

Daniel Thomas wrote:

> Hi David,
> 
>> January 15, 2004 a.c. - 15:21:43 CET becomes:
>> D20040115T142143Z
>>
>> March 19, 348 b.c. becomes:
>> C03480319T000000Z
> 
> 
> I think I must be missing something here.
> 
> Let's have a look at four dates along the timeline:
> Jan 15 2004 b.c
> Jan 15 348 b.c.
> Jan 15 348 a.c.
> Jan 15 2004 a.c
> 
> I assume that a normal OrderBy in an SQL Statement were to return the 
> following:
> 
> C03480115T000000Z
> C20040115T000000Z
> D03480115T000000Z
> D20040115T000000Z
> 
> Which would be no good. As for all b.c. dates the ordering would point 
> into the past and for all a.c. dates into the future.
> So either the b.c. dates or the a.c. dates would come in the wrong order.
> 
> Right?

Right.

Anyway that's what I wrote or at least meant to write in my post.

C and D won't solve the problem.

Masi