[thelist] Date and Time issue Worldwide

Paul Backhouse paul.backhouse at 2cs.com
Tue Apr 16 09:03:01 CDT 2002


Hmmm - i believe this is dictated by the regional settings of the server SQL
server is on. I have just checked and mine defaults to UK date because the
machine is built with regional setting to UK.

As for you're young - me: 1978/01/25

If you want to know how to change the regional settings let me know and il
tell you.

cheers

paul
-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Rob Smith
Sent: 16 April 2002 14:50
To: 'thelist at lists.evolt.org'
Subject: RE: [thelist] Date and Time issue Worldwide


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





More information about the thelist mailing list