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.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Setting Default Date Format

Author  Topic  anton Starting Member 5 Posts Posted - 2000-10-06 : 06:31:34 I have been searching the SQL online books, but i cannot find how to set the SQL Server to use a specific date format. I want all dates to be treated as dd/mm/yyyy or dd-mmm-yyyy etc.. Anything but american style mm/dd/yyyy!!! I know you can use set dateformat but as far as i can figure out, you have to use a set datefirst before each 'execution'. In a nutshell: How do i set the server's global date format setting? Thank you!