Hi
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?
ragards
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To
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
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
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
4 matches
Mail list logo
