storing timestamp and finding the difference

[prakash]

How can I store current time stamp to database

and check if the difference of two time stamp is 10minutes or not.

[prakash]

any help??

[mmarif4u]

for Current date to store from php:

 

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

[freebsdntu]

try NOW() function from mysql

[corbin]

INSERT INTO times (time) VALUES (NOW());

 

SELECT * FROM times WHERE time < NOW() - 600;

[mmarif4u]

for Diff:

 

$date=Retrieve from db;
$thendate = strtotime($date); OR $thendate=date('d m Y H:i:s',strtotime($date));
$nowdate = date('d m Y H:i:s');

$datediff = ($nowdate - $thendate);

echo $datediff." Seconds<br>";
echo round($datediff / 60)." Minutes<br>";
echo round($datediff / 3600)." Hours<br>";
echo round($datediff / 86400)." Days<br>";

[corbin]

$nowdate = date('d m Y H:i:s');

 

$datediff = ($nowdate - $thendate);

 

 

Errrr......  You're subtracting from a string?

[mmarif4u]

Oh sorry:

 

That would be like this

<?php
$nowdate = strtotime("20 January 2008");
$thendate = strtotime("4 March 2007");
$datediff = ($nowdate - $thendate);

echo $datediff." Seconds<br>";
echo round($datediff / 60)." Minutes<br>";
echo round($datediff / 3600)." Hours<br>";
echo round($datediff / 86400)." Days<br>";

?>

Works fine.

[prakash]

I found this one:

<?php
function timeDiff($firstTime,$lastTime) {
// convert to unix timestamps
$firstTime=strtotime($firstTime);
$lastTime=strtotime($lastTime);

// perform subtraction to get the difference (in seconds) between times
$timeDiff=$lastTime-$firstTime;

// return the difference
return $timeDiff;
}

//Usage:
echo timeDiff("2002-03-16 18:56:32","2002-04-16 10:00:00");
?>