Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date format in SSMS
Message
From
19/07/2011 19:33:38
Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada
 
 
To
19/07/2011 19:24:40
Charles Hankey
Consultant
Cleveland, Ohio, United States
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: Date format in SSMS
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01518555
Message ID:
01518564
Views:
37
>Could it have something to do with culture. DD/MM/YY vs MM/DD/YY - that could give you out of range values if a day of 30 was being seen as a month.

We just verified in SSMS, from a select * from field, and the date display is exactly the same format on both PC. It seems to be related to Windows itself which might take over the SSMS configuration. Could it be?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform