[AccessD] SQL 2005 - disambiguous DateTime format

Hi Borge

The ISO format, YYYY-MM-DD is the preferred format (just browse the documentation) for SQL Server 2008.
It is certainly safe for 2005 as well and required(!) for ADO when filtering on dates.

/gustav

>>> pcs.accessd at gmail.com 16-08-2008 10:05 >>>
Hi all,

I SQL 2005 I have adopted to routine of always passing a DateTime format for
whatever purpose in the format of a string:

YYYY-MM-DD

in order to be sure that the date is interpreted correctly irrespective of
locale setting of the computer


Now some colleagues are telling me to use format DD-MMM-YYYY is the -only-
safe way.

I would think that both methods of passing a date would be -safe-

(To avoid misinterpretation of 4/8/2008 - is it 4 August 2008 or 8 April
2008?)

Any pointers to KB article or other than explains this in more detail?

Regards
Borge