Return to Snippet

Revision: 1875
at November 17, 2006 03:31 by wolfie


Initial Code
SELECT unix_timestamp(current_timestamp) - unix_timestamp(time_field) AS timediff
FROM table_name;

Initial URL

                                

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

Initial Title
How to determine a timeout using unix time in mysql

Initial Tags
mysql, sql

Initial Language
SQL