Re: Date Format
  Home FAQ Contact Sign in
microsoft.public.sqlserver.setup only
 
Advanced search
POPULAR GROUPS

more...

 Up
Re: Date Format         

Group: microsoft.public.sqlserver.setup · Group Profile
Author: Tibor Karaszi
Date: Sep 18, 2008 09:15

Are we talking about input or output? Check out http://www.karaszi.com/SQLServer/info_datetime.asp
for elaboration

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

"Dan Bridgland" gmail.com> wrote in message
news:fcc4d468-07e3-4908-9398-57592982458c@p25g2000hsf.googlegroups.com...
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 -
no comments
diggit! del.icio.us! reddit!