Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-09 : 10:07:21
|
| vijay writes "Hello Guru,I would like to have a sql query displaying the current date format of the sql server. Just like how we can know date format in case oracle using nls_date_format. Thanx in advance,Regards,vijay" |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-01-09 : 10:12:56
|
| select getdate()should give you the date in the current format. ----------------------------Anything that Doesn't Kills you Makes you Stronger |
 |
|
|
davidpardoe
Constraint Violating Yak Guru
324 Posts |
Posted - 2002-01-09 : 10:25:34
|
| dbcc useroptionswill return the DATEFORMAT setting (amongst others) - basically this is the order of month, day and year============The Dabbler! |
|
|
|
|
|
|
Getting date format