Friday, January 13, 2017

MYSQL Query for Timestamp Age in Hours

SELECT `route_id` FROM `route` where `is_active`=1
AND TIMESTAMPDIFF(HOUR,`dt_update`,CURRENT_TIMESTAMP())< 48;

No comments: