2015/04/10

How to select records that has unix_timestamp and differs in minutes in MySql ?

SELECT *
FROM proxy
WHERE status = 'active'
AND TIMESTAMPDIFF(MINUTE, FROM_UNIXTIME(blocking_date), CURRENT_TIMESTAMP) > 60 * 4))
ORDER BY total_ping_counter
view raw gistfile1.sql hosted with ❤ by GitHub

No comments:

Post a Comment