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 >