Demo of getting seconds ago from DB

gistfile1.txt

mysql> SELECT time, NOW() - time as seconds_ago FROM time_test;
+---------------------+-------------+
| time                | seconds_ago |
+---------------------+-------------+
| 2011-05-01 12:43:58 |         142 |
| 2011-05-01 12:44:04 |          96 |
| 2011-05-01 12:44:24 |          76 |
+---------------------+-------------+
3 rows in set (0.00 sec)

-- CREATE TABLE time_test (time TIMESTAMP NOT NULL);
-- INSERT INTO time_test VALUES(CURRENT_TIMESTAMP());