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 |
|
chetanb3
Yak Posting Veteran
52 Posts |
 Posted - 2011-01-25 : 01:09:22
|
| I want to check the date format on my server and database..I think date format is different on server level and daabse level?How can i check? |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-01-25 : 03:41:27
|
| dbcc useroptionsMadhivananFailing to plan is Planning to fail |
 |
|
|
chetanb3
Yak Posting Veteran
52 Posts |
Posted - 2011-01-25 : 07:03:09
|
| I guess this command will give me server level date setting.. Is is possible ot have different date setting at database level? if yes how can I check current date setting? |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2011-01-25 : 07:23:09
|
| I don't think you can have the database setting separate. However, someone could change the setting locally in a stored procedure using the SET DATEFORMAT commandJimEveryday I learn something that somebody else already knew |
|
|
|
chetanb3
Yak Posting Veteran
52 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-01-27 : 04:41:21
|
| The current date format is for a session only. As soon as the session is closed it is reset to default settingMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
How can I check current date format?