MySQL Forums
Forum List  »  PHP

Re: PHP and MySQL time not same
Posted by: Nirmal Natarajan
Date: September 11, 2009 12:46AM

The problem is corrected.
MySQL installed on Windows uses the timezone description tables provided by MySQL. The description tables have leap seconds enabled. Disabling them solved the problem:

UPDATE mysql.time_zone SET Use_leap_seconds ='N';

After this, the server must be restarted.



Edited 1 time(s). Last edit at 09/11/2009 12:46AM by Nirmal Natarajan.

Options: ReplyQuote


Subject
Written By
Posted
September 10, 2009 07:31PM
Re: PHP and MySQL time not same
September 11, 2009 12:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.