An excerpt from the mysql manual:
---
1.7 Year 2000 Compliance
MySQL itself has no problems with Year 2000 (Y2K) compliance:
MySQL uses Unix time functions and has no problems with dates until 2069
---
However, it seems to me that this is the way to go indeed, because you can alw
Hi Olav,
> I have a database that is supposed to last more than 30 years
> Could someone advice me how to calculate (add and subtract) time in a maner
> that willl be correct after 2030 when Unix Time stop working?
if you are using MySQL, then use datetime or date column type.
they can support d
Use 64bit integers! They'll count up to a much higher number and will last
way beyond 2038.
In the database, set the correct type (INT8 in PostgreSQL, dont know about
the others). Dont worry about PHP as I'm sure there'll be a few newer
versions supporting wider int formats before then (if
3 matches
Mail list logo
