SQL Server 2005 Express cannot update datetime field when windows is set to Italian?

You should use region-independent dates. In SQL Server, you can do this.

You should use region-independent dates. In SQL Server, you can do this: UPDATE MyTable SET StartDate={ts '2009-07-14 12:05:30'} WHERE ID=7 From code, it's even better is to use named parameters and pass a DateTime object as parameter.

Thanks that works! – Roy Jul 13 '09 at 11:30.

UPDATE MyTable SET StartDate='20090714 12:05:30' WHERE ID=7.

Sorry it did not work, but I now think it was because VB.net replaced the ":" by ". ". No idea why.

– Roy Jul 13 '09 at 11:39.

After some hours of trying I found the solution. The ISO 8601 format works perfect in MS SQL, but something went wrong in formatting the date in VB.net. First I used the following format specifier: Dim dateString As String = aDate.

ToString("yyyy-MM-ddTHH:mm:ss") However, somehow the result is something like "2009-07-14T12. 09-07-14" instead of "2009-07-14T12:05:30", so dots instead of ":"! When using Dim dateString As String = aDate.

ToString("s") The correct format is applied: "2009-07-14T12:05:30".

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.