date

Locales and date format in SQL

I am working on a VB.NET project. The program is a Windows service that connects to an MS Access database. Everything worked fine on my own pc, but on another pc, we ran into some problems. It appeared to be related to regional settings. By default, the service ran as the LocalSystem account. I don’t know how to change the settings for that account, (anyone?) so for testing we ran the service under different user accounts. And indeed, for a user with “en-US”-settings, everything worked fine, but for a user with “nl-NL”-settings, we got weird results.

› Continue reading

Tags: , , , ,

Tuesday, January 23rd, 2007 Computing 2 Comments