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. > > > if(

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) ."'; ";