Hi
You need to use the strtodate function which converts to a time stamp a
date string and you can offset it by a number of days or whatever
something like this
<?
$start = "2002-01-01";
$expire = date("Y-m-d",strtotime("+30 days",strtotime($start)));
echo $expire."<br>";
?>
Tom
At 02:03 PM 19/05/2002, Andre Dubuc wrote:
>Two columns in my PostgreSQL db are type 'date' (formatted 'YYYY-mm-dd'):
>'start_date' and 'expiry_date'. What I cannot seem to figure out is how to
>augment the 'expiry_date' either by 30 days, 60 days, or 1 year.
>
>I've tried the date function in PHP (getdate) but the problem is that it
>appears to need a timestamp of "today". The dates that I'm trying to augment
>are sometimes a year or two ago.
>
>This doesn't work:
>
>$new_expiry_date = $expiry_date("Y-m-d", mktime(0,0,0, date(Y), date(m),
>date(d) + 60)));
>
>I assume it's because the '$expiry_date' should be simply 'date', but that
>would give the current date which is not what is wanted. Is there anyway to
>set 'date' as '$expiry_date'?
>
>Suggestions, admonitions, and general advice will be greatly appreciated.
>Btw, I've searched the archives, and haven't found anything quite on this
>topic.
>
>Tia,
>Andre
>
>
>--
>Please pray the Holy Rosary to end the holocaust of abortion.
>Remember in your prayers the Holy Souls in Purgatory.
>
>May God bless you abundantly in His love!
>For a free Cenacle Scriptural Rosary Booklet: http://www.webhart.net/csrb/
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
