I am facing a problem in SET time_zone
mysql_query("SET time_zone = '+4:00'") or die("");
mysql_query("insert into `aa` set mytim = now()") or die("");
I expect this to insert time GMT +4 time in database but it does not do that. how can i do that? i have field of "timestamp" type and i want to insert FMT +4 time in it when updated.
any help please
insert into aa(mytim)
values(current_timestamp + interval '4' hour)