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

[Jörg Rosenkranz]

Hello John,

> -----Original Message-----
> From: John BouAntoun [mailto:jbouantoun at rogen.com.au] 
> Sent: Thursday, July 14, 2005 2:12 AM
> To: Jörg Rosenkranz; Hubert FONGARNAND; 
> 
> 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.

We aren't using ISO dates for user interaction too. The date
is displayed and can be input in the current locale. In our
case (Germany) this is MM.dd.yyyy. ISO dates are used whenever
dates need to be stored or transmitted as strings (i.e. XML
files, SQL statements, ...).

Joerg.