> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 13 September 2007 15:32 > To: mysql@lists.mysql.com > Subject: MySQL DateTime Source on CentOS 5 > > > 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
I suspect MySQL is configured with a differect timezone/locale from your OS. See http://dev.mysql.com/doc/refman/5.0/en/localization.html for info. Edward -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]