I'm using SET time_zone = 'US/Hawaii' to convert timezones and it's not
working.
What am I doing wrong?
I have verified that the session.time_zone var is set correctly.
if(defined('ZMM_USER_LOCALE')) {
$query = "SET time_zone = '" .
mysql_real_escape_string(ZMM_USER_LOCALE) ."'; ";
$sel_result = @mysql_query($query);
}
$query = "SELECT `int_resp_id`, ....";
$sel_result = @mysql_query($query);
If I make the second $query = "SELECT NOW()" I get the correct time
adjusted values.
Does this method only work for INSERTS or when you want to adjust the
NOW() value? Not for pulling select statements out of the db?
