Difference in PHP timestamp and mysql timestamp

Question

I am really upset with the script I made, in which I did comparison of timestamps. I can see that the timestamps are totally different.

For 2012-10-02 03:06:21, timestamp is: 1349190381
For 2012-10-02 04:00:50, timestamp is: 1349150450

I can't understand why the second one timestamp is lower than the first, even if the time is bigger. How can I compare two dates?

I am getting these values by strtotime() function.

Clarification: I am using

$current_timestamp = strtotime(date('Y-m-d H:i:s'));

$till_date_timestamp = strtotime($database_object->till_date);

It would be good to see the code you have used to generate these timestamps. — ajtrichards
– ajtrichards, Commented Oct 2, 2012 at 15:10
Is the MySQL server on the same server? May be a timezone and/or difference in time between two machines causing this. — Ren
– Ren, Commented Oct 2, 2012 at 15:12
Have you tried just comparing time() with strtotime($dbobj->till_date) ? Still wouldn't cater for timezone differences between PHP and MySQL though. — Ja͢ck
– Ja͢ck, Commented Oct 2, 2012 at 15:20

Marc B · Accepted Answer · 2012-10-02 15:12:35Z

2

You sure you did it right?

mysql> select from_unixtime(1349190381), from_unixtime(1349150450);
+---------------------------+---------------------------+
| from_unixtime(1349190381) | from_unixtime(1349150450) |
+---------------------------+---------------------------+
| 2012-10-02 09:06:21       | 2012-10-01 22:00:50       |
+---------------------------+---------------------------+
1 row in set (0.00 sec)

php > echo date('r', 1349190381), "\n", date('r', 1349150450);
Tue, 02 Oct 2012 10:06:21 -0500
Mon, 01 Oct 2012 23:00:50 -0500

what string did you use in your strtotime calls? The function CAN mis-interpret inputs and should not be trusted on anything but well-formed and unambiguous date strings.

answered Oct 2, 2012 at 15:12

Marc B

362k44 gold badges433 silver badges508 bronze badges

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

Comments

ddinchev · Accepted Answer · 2012-10-02 15:22:30Z

2

Don't rely on strtotime! Also it's obvious that the timezone of PHP is different then the timezone of the database. Make sure the timezones are the same or get current/till timestamp like this (so that they are from one source):

SELECT UNIX_TIMESTAMP() AS 'Current' UNIX_TIMESTAMP(`datefield`) AS 'Till' FROM `table`

answered Oct 2, 2012 at 15:22

ddinchev

34.8k28 gold badges95 silver badges138 bronze badges

Comments

Teena Thomas · Accepted Answer · 2012-10-02 15:19:03Z

1

this is the result that i got. They differ from what you mentioned in the question.

Code:

    echo strtotime('2012-10-02 03:06:21'); //outputs: 1349147181
    echo "\n";
    echo strtotime('2012-10-02 04:00:50'); //outputs: 1349150450

Edit:

$till_date_timestamp = strtotime($database_object->till_date); make sure that $database_object->till_date is a string.

edited Oct 2, 2012 at 15:19

answered Oct 2, 2012 at 15:14

Teena Thomas

5,2091 gold badge15 silver badges17 bronze badges

Collectives™ on Stack Overflow

Difference in PHP timestamp and mysql timestamp

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related