Date Format for SQL Server

[pius]

Hi

I am having a problem with storing/updating Dates in SQL Server.
The generated SQL Statement looks like this:

UPDATE myTable SET date1='2010-06-05 00:00:00.0' WHERE (myTable.id='1')

The date which should be stored is June 6, 2010 but as of regional settings of SQL Server (German) the Date is interpreted as May 6, 2010.

I think the correct syntax for SQL Server should be

UPDATE myTable SET date1='20100605 00:00:00.0' WHERE (myTable.id='1')

Is there a way to solve this problem?

Thank you

[Isomorphic]

This seems a little strange. However, we have introduced a new configuration property which allows you to control the datetime format used in queries for the SQL Server database. By default, its value is 'yyyyMMdd hh:mm:ss'.

This new support will be present in nightly builds as of tomorrow. Please let us know whether this fixes your problem.