[Typo3-dev] Dates in non-UNIX format

[Daniel Thomas]

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?

Greetings Daniel


--/

Daniel Thomas dpool

Hinderink und Thomas Partnerschaft IT-Berater und Projektmanager

Zenettistr. 20 | D-80337 München
t 08945227582 | m 01793918781 | fax 08945227583

http://www.dpool.net | http://www.typergy.com

/--