Wednesday November 25th

2 Kicks

SQL Server: The one and only locale insensitive date format

Until recently i've been sure that there are 2 date formats that are completly locale insensitive. Those 2 i are yyyy-mm-dd HH:mm:ss.fff and yyyymmdd HH:mm:ss.fff. And i was proven wrong a few days ago!


Wouldnt kick this one. The author is purely wrong.

ISO date will never work as yyyy-dd-mm and i would treat that as a user-bug not an error with the system/database.

yes it wouldn't and that is exactly the point of the post.
yyyy-dd-mm isn't locale / date format insensitive so it can't be used by default.

Commenting on Stories is limited for now and will open up to those recommended by the community. Learn how
Loading DotNetKicks...
brought to you by the Kicks Network