Timeline for YYYY-MM-DD has changed to YYYY-DD-MM after moving SQL Server to new domain how do I switch back?
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 14, 2012 at 6:46 | vote | accept | Alex Andronov | ||
| Feb 13, 2012 at 14:33 | comment | added | Alex Andronov | @MartinSmith Thanks Martin... That seems to be the answer. When moving the domain the accounts were recreated as default in British English rather than English! | |
| Feb 13, 2012 at 14:28 | comment | added | Martin Smith | @AlexAndronov - British English is not the correct language for this format. Check what the login in your old server was using. For me it fails under "British English" but succeeds under "English" or "Simplified Chinese". My guess is that your old login was using US English. | |
| Feb 13, 2012 at 14:28 | comment | added | Lamak |
@AlexAndronov - In any case, you should always specify the date style on your convert, to avoid this problem. In your case, you should do: SELECT CONVERT(DATETIME,'2012-02-13',120)
|
|
| Feb 13, 2012 at 14:28 | comment | added | Alex Andronov | I have gbn... Sorry I wasn't clear in my comment. I have checked the logins default language and it is also British English. | |
| Feb 13, 2012 at 14:25 | comment | added | gbn | no, your logins have a different default language. What does the quote in my answer say? Have you read it? | |
| Feb 13, 2012 at 14:22 | comment | added | Alex Andronov | The problem here seems to be that the default language is British but it the database is still using yyyy-dd-mm for some reason. | |
| Feb 13, 2012 at 14:03 | history | answered | gbn | CC BY-SA 3.0 |