Search the Community
Showing results for tags 'mysql count by hour'.
Found 1 result
-
I need to pull the total count for a table but only for rows timestamped within that current. For example: if it's 18:59pm whe query executed, then only records with time logged within 6:00 to 6:59 should be counted base on: select count(id) from leads; Note: I need some suggestions on WHERE clause to only filter on that current hour - and the current date (itself). for example: if cdate has records - all from 2013-06-28 thru 2013-07-02 - and the current time of the query is 18:59 (which is 6:59), then only records with times between 18:00 to 18:59 for 2013-07-02 should show. Note: the date & time is in datetime format: 2013-07-02 18:47:24 What would be the WHERE clause to filter on just those rows between 18:00 to 18:59 for current date - having that hour change (at the top of every hour so only that CURRENT hour's set of records always returned in query)?
