Getting the dateformat

Hi,
I'm using MS SQL Server 2000.I need to get the current dateformat from
the server.I know set dateformat command, I tried "select dateformat",
it is showing error.Is there any query or function or procedure to get
the current dateformat.
Thanks & Regards,
ManikandanHi,
Use the below dbcc to get the user options. Dateformat is one amoung them.
DBCC USEROPTIONS
Thanks
Hari
SQL Server MVP
<plmanikandan@.gmail.com> wrote in message
news:1157459291.207274.308070@.h48g2000cwc.googlegroups.com...
> Hi,
> I'm using MS SQL Server 2000.I need to get the current dateformat from
> the server.I know set dateformat command, I tried "select dateformat",
> it is showing error.Is there any query or function or procedure to get
> the current dateformat.
> Thanks & Regards,
> Manikandan
>