Re: using SET time_zone for localization

2006-01-18 Thread Gleb Paharenko
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.

using SET time_zone for localization

2006-01-17 Thread John Lauck
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) .'; ;