Dates are traditionally a nightmare. Is it US or English? 2 digit years or 4 digit?

To get dates into SqlServer isn't that tramuatic.  Give it to the server in ISO format (yyyy-MM-dd HH:mm:ss) and all is hunky dory.  Or so I thought!!

We had an issue on a server that one of our client's maintain that has it's local set to "English (United States)" and it was giving us all sorts of date problems being it was in a differnt locale to our application.  Turns out there's a connection string property, which I'd never heard of, which can force the locale of your connection to something appropriate

language=British

sorted it out for us anyway.  Now, all locale specific information is set to the same as out app :¬)