CODEWITHSUNDEEP
mysqldatetimedatecount
gautamlakum
gautamlakum

Reputation: 12015

mysql: get record count between two date-time

I am stuck with a problem in MySQL. I want to get the count of records between two date-time entries.
For example:
I have a column in my table named 'created' having the datetime data type.

I want to count records which were created date-time between "TODAY'S 4:30 AM" and "CURRENT DATE TIME".

I tried some of MySQL's functions but still no luck with it.

Can you please help me with this? thanks.

Upvotes: 47

Views: 203468

Answers (4)

Aditya Tomar
Aditya Tomar

Reputation: 890

for speed you can do this 

WHERE date(created_at) ='2019-10-21'

Upvotes: 1

Harry Joy
Harry Joy

Reputation: 59660

May be with:

SELECT count(*) FROM `table` 
where 
    created_at>='2011-03-17 06:42:10' and created_at<='2011-03-17 07:42:50';

or use between:

SELECT count(*) FROM `table` 
where 
    created_at between '2011-03-17 06:42:10' and '2011-03-17 07:42:50';

You can change the datetime as per your need. May be use curdate() or now() to get the desired dates.

Upvotes: 99

Shakti Singh
Shakti Singh

Reputation: 86366

select * from yourtable 
   where created < now() 
     and created > concat(curdate(),' 4:30:00 AM')

Upvotes: 5

Wes
Wes

Reputation: 6585

select * from yourtable where created < now() and created > '2011-04-25 04:00:00'

Upvotes: 6

Related Questions