News for hackers. Stuff that matters.
Re:What every programmer should know about time by altrego99 on Monday July 04, 2011 @01:39AM (#2725512)
MySQL (at least 4.x and 5.x) stores DATETIME columns as a "YYYY-MM-DD HH:MM:SS" string

Wow that's terrible!

Re:What every programmer should know about time by ReturnTheGift on Monday July 04, 2011 @02:24AM (#2725592)
And false. See lysol's reply or the 5.0 reference manual's section on storage requirements:

http://dev.mysql.com/doc/refman/5.0/en/storage-requirements....

"YYYY-MM-DD HH:MM:SS" is the format of the DATETIME datatype. That's all.