[SOLVED] date()

[johnwayne77]

i'm working on a cron job function

 

i have an orders table with 'date_added' field like this:

 

date_added :  2009-02-28 07:19:33

 

i want to add two hours to the date_added value...

 

then after i have the date_added+2 hours in a variable i want to perform different tasks.. but that's my main condition..

 

how do i add two extra hours to a already added date?

 

i managed to add two extra hours to current date.. but that doesn't help.. : echo date("Y-m-d H:i:s", time()+((60*60)*2));

 

thanks

[premiso]

MySQL Addtime

 

or

 

MySQL Adddate

 

Not sure which is best, but yea. I would add the 2 hours in mysql and save some php processing time/conversion.

[johnwayne77]

i got it:

 

$ago = 2; // ore
$timestamp = time() - ($ago * 3600);
$final = date("Y-m-d H:i:s", $timestamp);

 

works fine