Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to change default date format to dd/mm/yy in SQL 6.5 ?

0 views
Skip to first unread message

Germà Guerra

unread,
Feb 25, 1998, 3:00:00 AM2/25/98
to

How to change default date format to dd/mm/yy in SQL 6.5 ?

Thanks for any help
--
Germà Guerra
Barcelona
Spain
zgue...@correu.gencat.es

Neil Pike

unread,
Feb 26, 1998, 3:00:00 AM2/26/98
to

Germa,

Look at the docs on how to add a language - the default language for a
user contains the date format.

Neil Pike MVP/MCSE
Protech Computing Ltd

Roberto Cano Ramos

unread,
Feb 27, 1998, 3:00:00 AM2/27/98
to

Echale un vistazo a SET DATEFORMAT

Kalen Delaney

unread,
Feb 27, 1998, 3:00:00 AM2/27/98
to

There are two sides to the date format question.

How do you want SQL Server to print out a date?

And, how do you want SQL Server to interpret a date that you enter, e.g.
should it interpret 3/4/98 as March 4th or April 3rd.

For the first, you can use the CONVERT function to print dates any way you
like. For the second, you'll have to use SET DATEFORMAT in every connection,
or install a new language, as Neil suggests.

--
Kalen Delaney
MCSE, SQL Server MCT, MVP

Germà Guerra wrote in message <01bd41e3$eba4ce30$1611b00a@pb5b17>...


>How to change default date format to dd/mm/yy in SQL 6.5 ?
>
>Thanks for any help
>--

>Germa Guerra
>Barcelona
>Spain
>zgue...@correu.gencat.es
>

Ian Posner

unread,
Mar 8, 1998, 3:00:00 AM3/8/98
to

I have to say, I think it's really lame of microsoft not to provide a
european english language option for easy setup (I know how to do it, but
many DBAs don't). Typically America-centric if you ask me...

--

Ian Posner
MindQuest Solutions Ltd
ipo...@dial.pipex.com
Kalen Delaney wrote in message ...

0 new messages