ASP.NET / SQL Server Express Locale / Date format settings
Posted on 2008-06-22
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.