If you change the regional settings on a machine running SQL Server, will it automatically recognize the settings and understand different date formats according to the regional settings? For example if I change my machine from English(US) to English(Canadian) will it understand the date format being passed of dd/mm/yyyy?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Regional Settings and SQL Server
- Thread starter jgos
- Start date
TheBugSlayer
Programmer
I don't think so. You will have to consider that when writing your queries. When your dates are stored on the server they will probably be changed to something your collation understands and...there can be some nasty surprises...
Please look for "international Transact-SQL statements" in SQL BOL.
Please look for "international Transact-SQL statements" in SQL BOL.
- Status
Similar threads
- Question
