Group: microsoft.public.sqlserver.setup · Group Profile
Author: Aaron Bertrand [SQL Server MVP]Aaron Bertrand [SQL Server MVP] Date: Sep 18, 2008 03:52
I strongly suggest changing to passing unambiguous date formats, e.g.
YYYYMMDD.
On 9/18/08 6:45 AM, in article
faf7acf9-d1c6-476b-9d4a-d1b3ef5d99dd@ y21g2000hsf.googlegroups.com, "Dan
Bridgland" gmail.com> wrote:
> Hi,
>
> Having just moved many of my databases over to SQL2005 I've just
> stumbled across a problem with US and UK date formats. My Stored
> procedures are set up for UK date format dd/mm/yy but the new SQL2005
> server want to put everything in US format mm/dd/yy
>
> How do I change SQL2005 to use the UK date format?
>
> Regards
> Dan
| 
