find new date based on given date

[Anon]

hello everyone!

I have a date that is entered into a database in the form of 2001/08/28. From this date I need to grab the date 90 days later. Which would be somewhere around 2001/11/27 in this example.

Any ideas on how to do this??
Thanks so much...

[Anon]

If you are using MySQL, its very easy =)

in your select statement (when you grab the date):

$res = mysql_query("SELECT UNIX_TIMESTAMP(datefield) FROM tableName ....");

Then your resulting info will be a unix epoch timestamp... to add 90 days

$row = mysql_fetch_array($res); // Only 1 field selected in example
$newtime = $row[0] + (606024*90);

$newtime now contains the time from the DB + 90 days

Hope this helps

Ceph