Monday, February 13, 2006

SQL Server US / UK Date HELL !

If you using VB and a SA login to connect to SQL server and want to write date to it using VB function like TODAY or NOW you need to execute this statement before doing that:

System.Threading.Thread.CurrentThread.CurrentCulture = New System.Globalization.CultureInfo("en-US")

It makes all the regiona stuff US so if you are sending something to a field like MONEY it would come as USD

Another way of doing this is to create a SQL server Login (Server/Security/Logins) and setup a new login set its language to British

use it for any connections and pass in normal date

No comments: