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'...
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.
4 Answers
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.
select * from yourtable where created < now() and created > '2011-04-25 04:00:00'
select * from yourtable
where created < now()
and created > concat(curdate(),' 4:30:00 AM')
for speed you can do this
WHERE date(created_at) ='2019-10-21'
James Sterling reports on renewable energy developments, climate policy, ecological conservation, and green tech innovations around the globe.
