PHP time ahead of MySQL time

Question

I run PHP and MySQL on the same machine, but both report different times.

I set the timezones by the following methods:

PHP:

date_default_timezone_set('Asia/Kuala_Lumpur');

MySQL:

SET time_zone = "Asia/Kuala_Lumpur";

The difference between two times is always exactly 24 seconds. Any idea why this is happening? I thought the times must be same because both reside on the same machine!

Are you sure that 24 seconds isn't passing between when you get the value from one & compare with the other? — OMG Ponies, Sep 11 '09 at 01:19
No, I am comparing both the times in the same scripting run. The maximum difference should be 1 second (if the second changes between first line and second line of code). — Nirmal, Sep 11 '09 at 01:26

score 1 · Accepted Answer · edited May 23 '17 at 10:27

1

see this question: Why does MySQL CONVERT_TZ alter the seconds after timezone adjustment?

edited May 23 '17 at 10:27

Community

1
1

answered Sep 11 '09 at 02:15

Craig

4,750
22
21

PHP time ahead of MySQL time

1 Answers1