Brainstorming re: storing accurate dates in a MySQL database. Currently thinking UTC'd DATETIME in addition to a timezone identifier column.
2 replies ¬
your account to reply
Why not a Unix Timestamp?
I'm using that right now, as it is by far the easiest, but I believe MySQL's implementation is a signed 32-bit integer. Anything but future proof.