I'm running Apache/MySQL/PHP5 on a CentOS 5 server and have started to get
some strange date and time inconsistencies between OS time and MySQL time
("now()").
1. MySQL Time:
[EMAIL PROTECTED] mysql -bA
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 5.0.22
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
([EMAIL PROTECTED]) [(none)]) select now();
+-----------------------------+
| now() |
+-----------------------------+
| 2007-09-13 14:07:37 |
+-----------------------------+
1 row in set (0.00 sec)
([EMAIL PROTECTED]) [(none)]) exit
Bye
2. OS Time:
[EMAIL PROTECTED] date
Thu Sep 13 08:09:12 STDST 2007
I'm at a loss as to where MySQL is getting this time from as it has always
matched the OS time.
Thoughts appreciated.
Thanks,
David
