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
Top comments (3)
Sure PostgreSQL can. Seems MySQL fixed it in 8.0.28: bugs.mysql.com/bug.php?id=12654
TIL. Is this a tough thing to work around if you need to date stuff way in the future for any reason?
Why not just use DATETIME format instead?
Postgres does it better (as usual :) ) and doesn't have the issue at all though, IIRC.