[SOLVED] Help with time comparison

[EchoFool]

I have two time stamps one from a database and one which is "now".

 

 

I was wondering if there was a way to compare the two to find out if the gap between them is greater than 20 minutes.

 

These are the two fields

 

<?php
$Date = $row['SkipDate']; // from database
$Date2 = date("Y-m-d H:i:s",time()); // now time
?>

 

Is it a possible thing to do ?

[kenrbnsn]

You get the UNIX timestamp of each field, subtract them, and compare the result to 1200 (20mins * 60secs).

 

<?php
$dt = strtotime($row['SkipData']); // this assumes the field is a normal date/time
$dn = time();
$x = abs($dt - $dn);
if ($x > 1200) echo "more than 20 minutes between the two dates";
?>

 

Ken

[unkwntech]

Try this

<?php
$date = $row['SkipDate'];
if($date > date('Y-m-d H:i:s', mktime('', date('i') +20))
{
//more then 20 minutes.
}
?>

[kenrbnsn]

That probably won't work since you're comparing ASCII strings, not integers.

This would also work:

<?php
if (strtotime($row['SkipDate']) > strtotime('+20 minutes')) echo "Greater that 20 minutes";
?>

 

Ken

[unkwntech]

I have used this with success before, although I will admit it may have been a bit different... I will have to try and find that code.

[EchoFool]

Thank you for your replies guys!

 

 

I will give your suggestion a try Ken. Thank you.