mysql get record count between two date-time

Question

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

User · Answer

select   from yourtable where created  lt  now   and created  gt   2011-04-25 04 00 00

User · Answer

May be with   SELECT count    FROM  table   where      created at gt   2011-03-17 06 42 10  and created at lt   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

User · Answer

for speed you can do this   WHERE date created at    2019-10-21

User · Answer

select   from yourtable     where created  lt  now         and created  gt  concat curdate     4 30 00 AM

[mysql] mysql: get record count between two date-time

Examples related to mysql

Examples related to datetime

Examples related to date

Examples related to count