Re: Date Format

Tech-Archive recommends: Fix windows errors by optimizing your registry

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]"
<ten....@xxxxxxxxxxxxxx> 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...@xxxxxxxxxxxxxxxxxxxxxxxxxxxx, "Dan



Bridgland" <DanBridgl...@xxxxxxxxx> 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 -

.

Relevant Pages