[Mono-devel-list] DateTime Parameters in MSSQL Server
jbouantoun at rogen.com.au
Wed Jul 13 20:11:37 EDT 2005
Thanks for this response, I never really considered what MMM would do in non-english speaking locales.
I agree with you that the ISO standard dates should be used for the software to SQL parameter passing since; after all it is the standard. However I will continue to use "dd MMM yyyy" in my date controls (i.e. the parts the users type into) since trying to get users to enter dates in ISO standard is virtually impossible.
From: mono-devel-list-bounces at lists.ximian.com [mailto:mono-devel-list-bounces at lists.ximian.com] On Behalf Of Jörg Rosenkranz
Sent: Wednesday, 13 July 2005 11:05 PM
To: John BouAntoun; Hubert FONGARNAND; mono-devel-list at lists.ximian.com
Subject: RE: [Mono-devel-list] DateTime Parameters in MSSQL Server
> -----Original Message-----
> From: mono-devel-list-bounces at lists.ximian.com
> [mailto:mono-devel-list-bounces at lists.ximian.com] On Behalf
> Of John BouAntoun
> I've found you can't go wrong with using abbreviated month
> name in either this format:
> dd MMM yyyy
> Or the other way around
> MMM dd yyyy
> Perhaps we should be doing this when we pass dates into sql server?
I think this only works because your month names are english too.
In other locales the month names are different. For us the best way
is to use ISO dates: "yyyy-MM-dd HH:mm:ss". This can be parsed in all
locales (at least I think so).
Mono-devel-list mailing list
Mono-devel-list at lists.ximian.com
More information about the Mono-devel-list