mysql数据库中服务器时间和时间戳之间的秒数差异

Question

I'm trying to display the difference, in seconds, between the current server time and a DATETIME (defined as 2012-01-01 00:00:01) entry in my database on a php page. I'm only wanting to display the difference for the latest entry.

I have been able to get some results, but I know the results aren't correct. If anyone is able to assist, that'd be great. Thanks!

Answer 1

It is as simple as:-

echo time() - strtotime('2012-01-01 00:00:01');

time() strtotime()