Re: Time calculation after UNIX
| From: | Jimmy | Date: | Wed, 16 Jan 2002 15:07:59 +0000 |
| Subject: | Re: Time calculation after UNIX | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-80717@lists.php.net to get a copy of this message | ||
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 date range from '1000-01-01' to '9999-12-31'.
and for calculation, you can use MySQL function:
ADDDATE() or SUBDATE()
--
Jimmy
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Bigamy is having one spouse too many. Monogamy is the same.