Get $page->created as Unix timestamp

[Ivan Gretsky]

Good day!

I need to have $page->created as a UNIX timestamp (UTC)  to compare it to time(). But I can't figure it out how to do it. I get the $page->created time in the future, later than time(). Please help!

[LostKobrakai]

Maybe a timezone issue?

[Ivan Gretsky]

I am really confused here. Please be so kind to explain. When I get $page->created as a timestamp, should not it be the same as 11 digits not depending on any timezone?

But when I create a new page and straight after that do something like this:
 

echo time();
echo $pages->get(1053)->created;

The first number is less than the second in an amount of seconds equal to an hour. I assume both of these numbers are UNIX timestamps and should be about the same, but they differ in an hour.

Edited August 1, 2016 by Ivan Gretsky

[LostKobrakai]

It should in theory, but I had issues where the mismatch came from mysql using another timezone than php, because created is "created" by sql NOW() and not in php afaik.

[Ivan Gretsky]

Unix timestamp should be the same on any server, shouldn't it be ?
Anyways, what should I check to make php and mysql consistent?

[LostKobrakai]

http://stackoverflow.com/questions/930900/how-to-set-time-zone-of-mysql

[Ivan Gretsky]

Yep, already there thanks.