News for hackers. Stuff that matters.

A comment on ISO 1.

Re:ISO 1 by sandstrom on Saturday November 09, 2013 @09:49AM (#6701743)
I wish ISO 8601 would have been the first one. Then, perhaps, we would not have this: http://xkcd.com/1179/
[ Parent | on HN ]
Re:ISO 1 by FrankenPC on Saturday November 09, 2013 @02:47PM (#6702856)
As someone who just wrote a universal international date/time conversion/comparison app for our portal...I FREAKIN concur.
[ Parent | on HN ]
Re:ISO 1 by downer99 on Sunday November 10, 2013 @04:08AM (#6705819)
The worst offender for all time has to be Oracle.

Outside of '01-JAN-1999', I am forever Googling "TO_DATE Oracle" because the string formats for precision time stamps always turn out to be counter-intuitive, and the exact opposite of what I expect.

Like:

  TO_DATE('01-JAN-1999 23:59:59', 'DD-MON-YYYY HH24:MI:SS')
God damn you, Oracle!
[ Parent | on HN ]