ASP.NET / SQL Server Express Locale / Date format settings

We recently migrated servers and on the new server ASP.NET websites are displaying the time format incorrectly.

Not sure if this is a result of .NET settings or SQL Server settings, but basically any website using ASP.NET / SQL Server (Express) is displaying the date format as: MM-DD-YYYY.

However it should be using the DD-MM-YYYY setting instead. In the server's control panel regional settings, this has been setup.

Wondering if the .NET framework or SQL Server maintain their own locale settings somewhere and if so, where can I find these settings (I've looked but been unable to find it).

Also, SQL server is currently running as the "Local System" account, if that makes any difference.
bradderickAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
JuckManConnect With a Mentor Commented:
it depend on where you are reading the datetime values from using .net method calls like Datetime.now or from the database.
If it is from database then use the following article to figure out what your current settings are and how to change it to a different one
http://www.karaszi.com/SQLServer/info_datetime.asp

hope this helps
0
 
bradderickAuthor Commented:
It's happening to values from the database - and on the old server this was fine.

Which is why I suspect maybe locale settings need to be changed in SQL server - but haven't been able to find where to do it from.

Note the server's locale settings (specified in the windows control panel) seem to be ignored by SQL server.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.