How do you check the current date format of an SQL Server 2005 database?

How do you check the current date format of a SQL Server 2005 database?
rbttAsked:
Who is Participating?
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
Hello rbtt,

dbcc useroptions  

and check for the dateformat

GOD BLESS,

Aneesh R.
0
 
rbttAuthor Commented:
I am new to MS SQL Server 2005.

How do I check DBCC user options?
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
ohh... that's a single statement, must be run on a new query window

DBCC USEROPTIONS

0
 
rbttAuthor Commented:
I see it  as : mdy

does that necessarily mean mm--dd--yyyy or could it be another day,month,year format?
0
 
chapmandewConnect With a Mentor Commented:
yep, that is what it means.

do this to make sure:

select getdate()  

it should return it in that format.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.