|
-
Date Format
Hi there!
Having a real nightmare with date formats on my SQL Servers.
Basically i can't insert a certain date, the query "select isdate('2000-12-31' returns 0 telling me the date is not a valid SQL Server date.
My SQL Server config uses British English and date format dmy. My NT Server Locale is British English and date format dmy etc, etc,
I don't want to use DATEFORMAT in my SQL to fix this - it needs to be fixed at the server level but, what other config settings are there?
The date unacceptable on all my SQL Servers except the one running desktop version! However, the SQL Server Locale and NT Server Locale are all the same (British dates, British English).
Can anyone help this sad Brit? Please!
Kyliedude.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|
Reply With Quote