MySQL 'timestamp' type column cannot store value beyond '2038-01-19 03:14:07' UTC, i.e., Int32 limit (2147483647).
What do you think about Postgres timestamp column. Can they?
MySQL 'timestamp' type column cannot store value beyond '2038-01-19 03:14:07' UTC, i.e., Int32 limit (2147483647).
What do you think about Postgres timestamp column. Can they?
For further actions, you may consider blocking this person and/or reporting abuse
Kamal Mustafa -
Mike Young -
Vaibhav Dwivedi -
Mike Young -
Top comments (3)
Sure PostgreSQL can. Seems MySQL fixed it in 8.0.28: bugs.mysql.com/bug.php?id=12654
Why not just use DATETIME format instead?
Postgres does it better (as usual :) ) and doesn't have the issue at all though, IIRC.
TIL. Is this a tough thing to work around if you need to date stuff way in the future for any reason?