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() |
+---------------------+
| 2003-01-14 17:41:20 |
+---------------------+
1 row in set (0.00 sec)
mysql> quit
Bye
[root@sql2 /root]# date
Tue Jan 14 12:41:32 EST 2003
[root@sql2 /root]#
Can anyone help?
Thanks!
- Ryan
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php