mysql timezone and php timezone

[UnknownPlayer]

I have set default time zone in php, but i have this sql statement:

 

DELETE FROM mytable WHERE date < DATE_SUB(NOW(), INTERVAL 30 DAY);

 

do i need to set default timezone in mysql becouse i use NOW() mysql function ?

[joel24]

yes you do. you need to put in the hour difference unless your mysql install is setup to accept textual timezones.

$currentOffset = "+".(date("Z") / 60 / 60).":00";

//timezone mysql
$update_tz = @mysql_query("SET time_zone = '$currentOffset'");

[UnknownPlayer]

But i cant use string "Europe/Belgrade" like i use in php ?

[UnknownPlayer]

It works in this way, thanks..