repost: select now() returns incorrect time

2003-01-15 Thread Ryan Babchishin
Sorry for the repost, I just want to make sure this didn't go unnoticed. I'm having trouble on one of my SQL servers. It is the slave in a master/slave setup. select now() returns the wrong time (+5 hours). The systems time is in EST and "show variables" shows timezone=EST. This has been very tr

select now() returns incorrect time

2003-01-14 Thread Ryan Babchishin
I'm having trouble on one of my SQL servers. It is the slave in a master/slave setup. select now() returns the wrong time (+5 hours). The systems time is in EST and "show variables" shows timezone=EST. Eg. mysql> select now(); +-+ | now() | +---