[Mono-devel-list] DateTime Parameters in MSSQL Server

Jörg Rosenkranz joergr at voelcker.com
Wed Jul 13 09:04:40 EDT 2005


Hello John,

> -----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).

Joerg.



More information about the Mono-devel-list mailing list