sql server clients: 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 forma

So if anybody can remember that... :O

Kind regard
Janus, Denmar

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


[quoted text, click to view]
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!
[quoted text, click to view]

The format of how something looks when displayed is a factor of the GUI in
which it is displayed and not a database function. You can choose to use
CONVERT() to force a particular string but that does defeat the ability for
2 different GUI's in to display the data in their local format. The setting
of SET DATEFORMAT is for input only. See here from BOL:

This setting is used only in the interpretation of character strings as they
are converted to date values. It has no effect on the display of date
values.

--
Andrew J. Kelly SQL MVP


[quoted text, click to view]
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!
[quoted text, click to view]