jSQL-Gen icon indicating copy to clipboard operation
jSQL-Gen copied to clipboard

TIMESTAMP 2038 problem

Open Osiris-Team opened this issue 1 year ago • 0 comments

TIMESTAMPS will break in 2038 because they are stored with 32 bits instead of 64. (MySQL) https://dev.mysql.com/doc/refman/8.4/en/datetime.html

Possible fix: Do not use TIMESTAMP internally but use some kind of wrapper and instead store a 64 bit long number. Or hope that the database software itself finds a fix some day.

Osiris-Team avatar Sep 12 '24 15:09 Osiris-Team