Group: microsoft.public.sqlserver.setup · Group Profile
Author: Dan BridglandDan Bridgland Date: Sep 18, 2008 04:05
Thanks for the advice, I see exactly where your coming form there.
How can I set that as the server default, as opposed to the US default
format?
Regards
Dan
On 18 Sep, 11:52, "Aaron Bertrand [SQL Server MVP]"
wrote:
> 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-d1b3ef5d9...@ 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- Hide quoted text -
>
> - Show quoted text -
| 
