计算比较sql时间戳和php日期（“y-m-d h：i：s”）

Question

Is there a way to see if ((the current time - a timestamp in a database)>10 minutes) in php? I have a row in a database called lockout. I have the following code so far:

echo $row['lockout'];//returns 2013-05-12 22:04:17
echo date("Y-m-d H:i:s")//returns 2013-05-12 22:06:32    

Furthermore does anyone have any ideas why when I insert the current Timestamp in my database, it is about a half hour off, but has the right date and year?

Answer 1

Use the http://www.php.net/manual/en/book.datetime.php datetime class in php This has a diff method