TIL: MySQL timestamp column can’t go beyond ‘2038-01-19 03:14:07’

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?


This content originally appeared on DEV Community and was authored by Xinecraft

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?


This content originally appeared on DEV Community and was authored by Xinecraft


Print Share Comment Cite Upload Translate Updates
APA

Xinecraft | Sciencx (2022-01-03T13:08:28+00:00) TIL: MySQL timestamp column can’t go beyond ‘2038-01-19 03:14:07’. Retrieved from https://www.scien.cx/2022/01/03/til-mysql-timestamp-column-cant-go-beyond-2038-01-19-031407/

MLA
" » TIL: MySQL timestamp column can’t go beyond ‘2038-01-19 03:14:07’." Xinecraft | Sciencx - Monday January 3, 2022, https://www.scien.cx/2022/01/03/til-mysql-timestamp-column-cant-go-beyond-2038-01-19-031407/
HARVARD
Xinecraft | Sciencx Monday January 3, 2022 » TIL: MySQL timestamp column can’t go beyond ‘2038-01-19 03:14:07’., viewed ,<https://www.scien.cx/2022/01/03/til-mysql-timestamp-column-cant-go-beyond-2038-01-19-031407/>
VANCOUVER
Xinecraft | Sciencx - » TIL: MySQL timestamp column can’t go beyond ‘2038-01-19 03:14:07’. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2022/01/03/til-mysql-timestamp-column-cant-go-beyond-2038-01-19-031407/
CHICAGO
" » TIL: MySQL timestamp column can’t go beyond ‘2038-01-19 03:14:07’." Xinecraft | Sciencx - Accessed . https://www.scien.cx/2022/01/03/til-mysql-timestamp-column-cant-go-beyond-2038-01-19-031407/
IEEE
" » TIL: MySQL timestamp column can’t go beyond ‘2038-01-19 03:14:07’." Xinecraft | Sciencx [Online]. Available: https://www.scien.cx/2022/01/03/til-mysql-timestamp-column-cant-go-beyond-2038-01-19-031407/. [Accessed: ]
rf:citation
» TIL: MySQL timestamp column can’t go beyond ‘2038-01-19 03:14:07’ | Xinecraft | Sciencx | https://www.scien.cx/2022/01/03/til-mysql-timestamp-column-cant-go-beyond-2038-01-19-031407/ |

Please log in to upload a file.



There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.

Related Posts