Posted By

wolfie on 11/17/06

Tagged

Viewed 2412 times

Favorited by 0 user(s)

/ Published in: SQL

This will return the number of seconds between now and when the time field was inserted.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

SELECT unix_timestamp(CURRENT_TIMESTAMP) - unix_timestamp(time_field) AS timediff
FROM TABLE_NAME;

You need to login to view comments.