KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am trying to get the all records which are 2 hours or more old using this query: $minutes = 60 * 2 SELECT COUNT(id) AS TOTAL, job_id from tlb_stats WHERE log_time >= DATE_SUB(CURRENT_DATE, INTERVAL $minutes MINUTE) GROUP BY job_id It only selects the recent records and skips the old. When I change log_time <= ... it only selects old and skips which are the new one. What am I doing wrong?
Tags (comma-separated)
Save Edits
Cancel