MySQL Query Count based on current hour

[n1concepts]

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)?

 

 

 

[kicken]

WHERE

  DATE(timeColumn)=CURDATE() 

  AND HOUR(timeColumn) = HOUR(NOW())

That compares the date portion of the timestamp column to the current date to limit the query to only rows for today, then the next bit compares the HOUR porition to the current hour, further limiting the result set to only the current hour's records.

[n1concepts]

Worked perfect!

Thanks!