Comments - FROM_UNIXTIME
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
it's time to change FROM_UNIXTIME(int) to at least FROM_UNIXTIME(unsigned int) moreover, that the function does not accept negative values. from_unixtime(2147483647)="2038-01-19 05:14:07" only 22 years left, unsigned value adds 68 years.
See MDEV-341. If you need to store dates outside of this range, don't use FROM_UNIXTIME.
do exists a possibility that FROM_UNIXTIME will become 64bit? else I resolve in other way, that is I remove the use of FROM_UNIXTIME. thanks
It's unlikely - see the note in the article about about using DATETIME instead.