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 |
|
Robwhittaker
Yak Posting Veteran
85 Posts |
 Posted - 2002-11-06 : 06:24:47
|
| Hi all,I've been trying to look for documentation on default date settings.Being in the UK, we want to set our server up so that if a user enters a date, it recoginised it the uk way around ie dd/mm/yy and not mm/dd/yy. Is there a general setting on the server to do this globally.ThanksRob |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-11-06 : 06:38:09
|
| I wouldn't recommend this - better to always pass dates round in yyyymmdd format and ensure that the presentation layer takes care of the format.You can set a startup parameter for sql server to set the date format and this will set the default.If the operating system is installed as UK, sql server is installed as UK and the service profile is also UK and the user connecting has a uk profile and this is not overridden anywhere then it should default to dd/mm/yyyy but I have seen some weird effects caused by mixing localles.Beware of any processing before the 13th of the month if you rely on implicit conversion of dd/mm/yyyy.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy.Edited by - nr on 11/06/2002 06:39:07 |
 |
|
|
|
|
|
Date Formats