Re: set date format?
From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 04/26/04
- Next message: STEVE SCHNEIDER: "Administrative Install"
- Previous message: Andrew J. Kelly: "Re: Reduce Log File Size"
- In reply to: Janus Knudsen: "set date format?"
- Next in thread: Andrew J. Kelly: "Re: set date format?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 26 Apr 2004 15:26:33 +0100
Hi
Setting the default language with sp_configure will give a default date
format, but that can be overridden with SET LANGUAGE or SET DATEFORMAT (for
input) on the connection.
John
"Janus Knudsen" <anonymous@discussions.microsoft.com> wrote in message
news:B4328BF7-6A2A-4624-97C0-DB348D9AA197@microsoft.com...
> Hello...
> As I remember I ran across a set statement that could control the
dataformat on the server?
>
> For instance:
> print cast(getdate as varchar) it returns current date and time in am/pm
format, but in Denmark we're not using this format, we're using 24hour
format. Obviously I could use CONVERT, but that's not an option in the
current scenario!
> The print output should be in 24hour format
>
> So if anybody can remember that... :O)
>
> Kind regards
> Janus, Denmark
>
- Next message: STEVE SCHNEIDER: "Administrative Install"
- Previous message: Andrew J. Kelly: "Re: Reduce Log File Size"
- In reply to: Janus Knudsen: "set date format?"
- Next in thread: Andrew J. Kelly: "Re: set date format?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
