Current Date Format

How do I know the current Date Format of the Database?
MadhivananMadhivanan (madhivanan2001@.gmail.com) writes:
> How do I know the current Date Format of the Database?
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.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks Erland
Madhivanan