Joerg, 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. Regards, -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jörg Rosenkranz Sent: Wednesday, 13 July 2005 11:05 PM To: John BouAntoun; Hubert FONGARNAND; [email protected] Subject: RE: [Mono-devel-list] DateTime Parameters in MSSQL Server Hello John, > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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). Joerg. _______________________________________________ Mono-devel-list mailing list [email protected] http://lists.ximian.com/mailman/listinfo/mono-devel-list _______________________________________________ Mono-devel-list mailing list [email protected] http://lists.ximian.com/mailman/listinfo/mono-devel-list
