7 years, 1 month ago Alexander G

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.

7 years, 1 month ago Ian Gilfillan

See MDEV-341. If you need to store dates outside of this range, don't use FROM_UNIXTIME.

2 years, 9 months ago oscar oxy

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

2 years, 9 months ago Ian Gilfillan

It's unlikely - see the note in the article about about using DATETIME instead.

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.