[BlueOnyx:01258] Re: MySQL time incorrect

[Colin Jack]

Hehe ... 

I will suggest they set the session time manually if I can't fix it, although it is a bit of a kludge.

Cheers

Colin


> -----Original Message-----
> From: blueonyx-bounces at blueonyx.it [mailto:blueonyx-bounces at blueonyx.it] On
> Behalf Of Jeff Jones
> Sent: Tuesday, May 19, 2009 1:36 PM
> To: BlueOnyx General Mailing List
> Subject: [BlueOnyx:01254] Re: MySQL time incorrect
> 
> How about hiring developers that work in GMT +5? :)
> 
> Have you tried:
> 
> SET SESSION time_zone = '+0:00'
> 
> Jeff
> 
> 
> 
> 
> On 19 May 2009, at 13:14, 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?
> >
> > Thanks
> >
> > Colin
> >
> >
> > _______________________________________________
> > Blueonyx mailing list
> > Blueonyx at blueonyx.it
> > http://www.blueonyx.it/mailman/listinfo/blueonyx
> 
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at blueonyx.it
> http://www.blueonyx.it/mailman/listinfo/blueonyx