Posted by Neil Smith [MVP Digital Media] on 04/05/06 17:40

Yup, that's how many databases store (or can be instructed to store)
decimal dates. In XSLT it has the nice side effect you can *always*
sort by dates in that format, because the numbers become sequential.

I've seen american posters jump through endless hoops in XSLT to sort
dates in their native format rather than using the scheme below ;-)

Cheers - Neil

On Wed, 05 Apr 2006 12:46:22 -0400, Bill
<trash@christian-horizons.org> wrote:

>Ohhh! Now I get it.
>
>Since I got my first computer, around 1986 (an Apple IIc) and needed to
>keep large numbers of files sorted chronologically, I have been using
>YYYYMMDD and I wish everyone would just get over it and switch over in
>North America, were we don't even seem to have a consensus on whether
>it's MMDDYYYY or DDMMYYYY. For the computer age, YYYYMMDD is most
>logical. The government should take the lead and declare a "standard".
>
>I look forward to 20060504030201 in about a month.
>
>Neil Smith [MVP Digital Media] wrote:
>
>> You mean 100 years - and except for Europe and the rest of the world
>> outside the USA - where this happens in 4 weeks since we write our
>> dates correctly as 04/03/05 ?
>>
>> Cheers - Neil

[Back to original message]