Manipulate datetime from mysql

[slackerJr]

Hello!

I need help with something, I need to fetch a datetime from a mysql database, add 5 minutes to it using PHP and finally insert the new date in the db again...


I got stuck on this, any suggestion?

 

[jpadie]

$val = "" //mysql datetime
$newval = strtotime("+ 5 minutes", strtotime($va));

but you could do it all in mysql

 

[sleipnir214]

Why pull the value into PHP to do that? MySQL's DATE_ADD() (link) function should allow you to add the 5 minutes through an UPDATE query.



Want the best answers? Ask the best questions! TANSTAAFL!

 

[slackerJr]

Thanks ppl for the quick help. The reason to do it in PHP is because I needed to do some other things with the manipulated date in PHP.