note 72412 added to function.date
| From: | code at ashleyhunt dot co dot uk | Date: | Wed, 17 Jan 2007 21:22:56 +0000 |
| Subject: | note 72412 added to function.date | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-121851@lists.php.net to get a copy of this message | ||
I wanted to shift an sql date forward by a set time period.
This is how I achived it... well handy.
<?
function sql_date_shift($date, $shift)
{
return date("Y-m-d H:i:s" , strtotime($shift, strtotime($date)));
}
// example usage
$date = "2006-12-31 21:00";
$shift "+6 hours"; // could be days, weeks... see function strtotime() for usage
echo sql_date_shift($date, $shift);
// will output: 2007-01-01 03:00:00
?>
Hope it is of use,
Ashley
----
Server IP: 69.147.83.197
Probable Submitter: 89.241.191.245
----
Manual Page -- http://www.php.net/manual/en/function.date.php
Edit -- https://master.php.net/note/edit/72412
Del: integrated -- https://master.php.net/note/delete/72412/integrated
Del: useless -- https://master.php.net/note/delete/72412/useless
Del: bad code -- https://master.php.net/note/delete/72412/bad+code
Del: spam -- https://master.php.net/note/delete/72412/spam
Del: non-english -- https://master.php.net/note/delete/72412/non-english
Del: in docs -- https://master.php.net/note/delete/72412/in+docs
Del: other reasons-- https://master.php.net/note/delete/72412
Reject -- https://master.php.net/note/reject/72412
Search -- https://master.php.net/manage/user-notes.php