[BlueOnyx:01255] Re: MySQL time incorrect

Tue May 19 07:40:07 -05 2009

Colin Jack wrote:
> On our BlueOnyx servers we are seeing a problem where the time on the server is correct (set on the GUI to GMT) but the result from MySQL when using the now() command gives 5 hours earlier - so EST. This obviously causes web site developers a problem on our servers.
> 
> Anybody able to help?

MySQL should read off your system's timezone.  Did you change your 
timezone?   If so, then a restart of MySQL service should fix.

Otherwise, you might have to use mysql_tzinfo_to_sql

-- 
Chris Gebhardt
VIRTBIZ Internet Services
Access, Web Hosting, Colocation, Dedicated
www.virtbiz.com | toll-free (866) 4 VIRTBIZ