/ Published in: SQL
![](/img/icon_sav.png?v3)
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;
Comments
![RSS Feed for Comments RSS Icon](/images/rss.png?v3)