Hello.
Perhaps this can resolve some queries:
http://lists.mysql.com/mysql/177314
John Lauck wrote:
> 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?
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
