quick question regarding now

[sabe]

okay, i don't know much about php and mysql but...

let's say i were to use the now() function in my .php file
i want to add 6 hours so it falls into the correct time zone, how do i do it?

[sabe]

I tried the following...

$timestamp = time();

$date_time_array = getdate($timestamp);

$hours = $date_time_array["hours"];
$minutes = $date_time_array["minutes"];
$seconds = $date_time_array["seconds"];
$month = $date_time_array["mon"];
$day = $date_time_array["mday"];
$year = $date_time_array["year"];

// use mktime to recreate the unix timestamp
// adding 19 hours to $hours
$timestamp = mktime($hours + 6, $minutes,$seconds ,$month, $day,$year);
$timetemp = date ("Y-m-d h:i:s",$timestamp);

================================

But it does not work because my data type in the database is DATETIME... anybody knows how to get around this

[ir4z0r]

either use
date("M d Y H:i:s",strtotime("+6 hours"))
or
gmdate("M d Y H:i:s")