How do I know the current Date Format of the Database?

Madhivanan

Madhivanan (madhivanan2***@gmail.com) writes:
There isn't one. The database itself does not have a date format. Dates
in SQL Server are stored as a binary value, as the number of days since
1990-01-01.

However, there is a session-specific setting for dateformat is controlled
with the command SET DATEFORMAT, and which also is affected by SET LANGUAGE
and the user's default language. This setting controls how date literals
are interpreted, nothing else. You can get this setting with help of
DBCC USEROPTIONS.

Thanks Erland

Madhivanan

NOLOCK
INSERT table (column1, column2) (@variable, '100')
Simple JOIN turned ugly - Help!
Is the SQL Server Service Running?
space(0) and replace('123-45', '-', '')