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. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]