SQL Server: The one and only locale insensitive date format

home
database
view story

3 Kicks

SQL Server: The one and only locale insensitive date format(weblogs.sqlteam.com)

submitted by spirit1(3160) 4 years, 3 months ago

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!

2 comments |category: Database |Views: 17
Tweet

tags: DateTime 2000 SQLServer Database 2005 another

Everyones tags:

Your Tags:

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

"Kick It" text
"Kick It" background
kick count text
kick count background
border

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

nova(0) -

kprernn(1445) -

spirit1(3160)

Comments:

posted by lysp(5) 4 years, 3 months ago 0

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.

posted by spirit1(3160) 4 years, 3 months ago 0

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.

Most Active Users

What's this?