Setting SQL Server to accept date in DD/MM/YYYY format
I’ve been working on a web based database project for the wifes business and during development I realised that half of the dates where being saved in M-D-Y format.
As I live in the UK we use the correct date format which is D-M-Y obviously ;).
The problem turned out to be a single settings on the SQL server:
Even though my SQL server, desktop and .net pages were all working with UK settings the setting turned out to be a single insidious setting within SQL Server (version 2010 express in my case):
To correct the behaviour you need to check that the user that is being used to connect to the database has their language settings set to British English instead of English. To do this:
Enterprise Management | Security | Logins, and change the settings from “English” to “British English”
Then you will need to fix all those incorrect dates…
Incidently isn’t it annoying that American English is referred to as ‘English’ whilst British English is somehow not ‘English’ ??? Surely America’s version of the English language should be called American or at least American English.
*credit for the fix must go to – link
In: ASP.NET, SQL, Tech · Tagged with: asp.net, database, dmy, sql
on 15 October 2015 at 23:07
· Permalink
I totally agree about the use of English vs American English. English is from England, obviously. We Americans speak a modified version for better or worse. Therefore our version of English can never truly be called English. I rather like the idea of calling it American, though American English is fine too. BTW I just love the English accent.