[AccessD] SQL 2005 - disambiguous DateTime format

Borge Hansen pcs.accessd at gmail.com
Sat Aug 16 05:16:55 CDT 2008


Thanks Gustav, I sort of expected you would be the one chiming in....

Are you saying that DD-MMM-YYYY would get you into trouble using ADO when
filtering on dates?
If so, do you have any documentation for this?

borge

On Sat, Aug 16, 2008 at 6:45 PM, Gustav Brock <Gustav at cactus.dk> wrote:

> 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
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



More information about the AccessD mailing list