Saturday, December 8, 2012

MySQL timestamp versus datetime

Storing a date according to UTC and automatically converting to the localized time upon retrieval, the way the MySQL database field type does, is something that appeals to me.

But, it looks as though the MySQL datetime type will store a date in excess of the UNIX 2038 date limit.

Followers