ISO 8601 - The correct way to represent a date

Question

ISO 8601 - The correct way to represent a date

Steven Willis

SSCrazy Eights

Points: 9893
More actions
February 27, 2013 at 11:32 pm

#290289

http://xkcd.com/1179/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Steven Willis (2/27/2013)
http://xkcd.com/1179/

Yes, but '20130227' is guaranteed to convert from a string to a date in SQL Server regardless of the setting of DATEFORMAT where as '2013-02-27' can be affected by this setting.