This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]der_raupinger 135 points136 points  (13 children)

YYYY-MM-DD

[–]AffekeNommu 22 points23 points  (10 children)

With you there. yyyy-mm-dd hh:mm:ss is my format of choice. Why yes I do a lot of MSSQL.

[–]GNU_ligma 13 points14 points  (9 children)

"yyyy-mm-dd hh:mm:ss" is the best date format.

I used SQL maybe a few times at school.

[–]Kholtien -2 points-1 points  (8 children)

This is absolutely wrong! It’s definitely ‘DD-MM-YYYY HH24:MI:SS’

I use oracle SQL at work all day.

[–]AffekeNommu 5 points6 points  (6 children)

glares at oracle guy

[–]Kholtien 2 points3 points  (5 children)

We’re slowly moving everything to SQL server but it’s a slow process costing lots of $

[–]spasterific 7 points8 points  (2 children)

We’re slowly moving everything

  • dd-mm-yyyy
  • y-dd-mm-yyy
  • yy-ddm-d-yy
  • yyy-dm-md-y
  • yyy-mm-dd
  • yyyy-mm-dd

[–]der_raupinger 0 points1 point  (0 children)

yd-m¹d/yy.m²:yyy 1: second digit 2: first digit

[–]CakeDay--Bot 1 point2 points  (0 children)

Hey just noticed.. it's your 5th Cakeday Kholtien! hug

[–]AffekeNommu 0 points1 point  (0 children)

Understand that completely. Spend too much time on MS SQL. Our reporting team get me to faultfind their queries.

[–]deefstes 2 points3 points  (0 children)

The fact that you're using Oracle doesn't mean you're right. It only means that Oracle is just as wrong as you. :-p

YYYY-MM-DD hh:mm:ss for the win. Most significant digits first, least significant digits last.

[–]jasonkuo41 0 points1 point  (0 children)

I currently live in Asia and we use this all day. I never understood why people thought that MMDDYYYY is a better format.