[thelist] Date and Time issue Worldwide

[Rob Smith]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]

Paul, this IS good stuff and I'll make sure I conform to ... something. But
the fact of the matter is that Enterprise Manager with SQL Server 7
automatically puts in American format: MM/DD/YYYY. ex:
5/8/02 -->> 5/8/2002
26/2/79 -->> 2/26/1979 (*my b-day* I know, I'm young)

Rob


This is the way to do it, ISO format, for further information see:

http://www.adopenstatic.com/faq/DateswithAccess.asp

I personnally use ASP and format my dates:

ISODate = Year(Now()) &"/"& Month(Now()) &"/"& Day(Now())

cheers

Paul

-----Original Message-----

Paul Cowan wrote on 16 April 2002 01:13:

>After all the date-related discussion, you can never go wrong with this:
><tip type="International Date Handling" author="Paul Cowan">
>Frustrated by illogical date formats? Simple. Always pass your dates to a
>database or other system with the format:
>	yyyy-mm-dd
>For example, Christmas 1999 is
>	1999-12-25


Absolutely agree 100 hundred 100% with this. Also makes sorting dates very
easy...

Kr,
Liam

--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !