set date format?

From: Janus Knudsen (anonymous_at_discussions.microsoft.com)
Date: 04/26/04 

Date: Mon, 26 Apr 2004 02:06:05 -0700

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

Relevant Pages