Your Ad Here

advanced code snippet search

Posted By

wolfie on 11/17/06


Tagged

mysql sql


Versions (?)

How to determine a timeout using unix time in mysql

 / Published in: SQL
 

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

Expand | Embed | Plain Text 
  1. SELECT unix_timestamp(current_timestamp) - unix_timestamp(time_field) AS timediff
  2. FROM table_name;

Report this snippet  

You need to login to post a comment.