Converting timestamp on server gives different result in PHP and MySQL

Question

Consider this. On my server, I convert a (UTC/GMT) timestring like this:

strtotime('Fri Feb 18 21:08:38 +0000 2011')

My server returns

1298063318

This is correct, since all unix timestamp converters that I tested, return the same. And vice versa, if I insert not the date but the timestamp, I get returned the timestring as given above. But if I convert the timestamp on my server:

date("Y-m-d H:i:s", 1298063318);

I get back a different date than expected (being 'Fri Feb 18 21:08:38 +0000 2011'):

2011-02-18 22:08:38

So it's off an hour. This is probably because my servers timezone is set at Europe/Paris, and it thus translates the timestamp into UTC/GTM + 1. But MySQL, ran on the same server and having the same timezone, gives me back another result:

SELECT FROM_UNIXTIME(1298063318) = 2011-02-18 22:08:15

In other words, it is off 18 seconds. Can somebody explain why?

diewie · Accepted Answer · 2012-04-08 13:26:08Z

4

For MySQL, a leap second correction is used for the date functions (MySQL Documentation). For PHP date functions, leap seconds are not taken into account. For that reason, you get now a 24 seconds difference.

You can try the following to solve your problem: http://pumka.net/2010/10/24/why-mysql-timestamp-is-24-seconds-different-from-php/

PS. 38 - 15 = 23

answered Apr 8, 2012 at 13:26

diewie

7644 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Pr0no Over a year ago

Would upvote twice if possible, just for the PS xD How did I miscalculate?! Must be the heavy breakfast.

Collectives™ on Stack Overflow

Converting timestamp on server gives different result in PHP and MySQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related