3 Kicks

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

submitted by spirit1spirit1(3160) 4 years, 7 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: |Views: 17

tags: another

new 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:
novanova(0) - kprernnkprernn(1445) - spirit1spirit1(3160)
Comments:

posted by lysplysp(5) 4 years, 7 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.

Reply

posted by spirit1spirit1(3160) 4 years, 7 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.

Reply

information Login or create an account to comment on this story
Submit a Story
View upcoming stories
How else can I help?
Add our feeds to your site

Most Active Users

What's this?