How to compare mysql timestamp with jquery timestamp?

Question

I have a timestamp value which return from mysql table. Now I need compare it with jquery timestamp to check whether time and date expired or not.

I have data like 2015-08-29 00:00:00 (Its from DB). But jquery return date value like this -> 13898736000 — Ramesh T, Aug 25 '15 at 04:53
Your Jquery date is a timestamp. Just convert either one to the other... In PHP: $ts = strtotime(2015-08-29 00:00:00); — Christoffer, Aug 25 '15 at 05:09

score 0 · Accepted Answer · edited May 23 '17 at 10:29

From this stackoverflow answer we get: difference between Jquery timestamp and php timestamp?

Timestamps in jQuery (as returned by $.now, which defers to Date.prototype.getTime) JavaScript are expressed in milliseconds. In PHP, (using time et al) they are in seconds.

So, we can write something like:

$time_php = strtotime(2015-08-29 00:00:00);
$time_js = 13898736000 * 1000;
if($time_php > $time_js) {
     echo"php time greater";
 }
 else{ echo"js time greater";}

How to compare mysql timestamp with jquery timestamp?

1 Answers1