mysql: get record count between two date-time

by

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.

More Related Contents:

  1. MySQL Query GROUP BY day / month / year
  2. Error in MySQL when setting default value for DATE or DATETIME
  3. Difference between two dates in MySQL
  4. How to select date from datetime column?
  5. How to cast DATETIME as a DATE in mysql?
  6. MySQL – select data from database between two dates
  7. How to compare timestamp dates with date-only parameter in MySQL?
  8. Working with INTERVAL and CURDATE in MySQL
  9. Complex Count in MySQL
  10. How to populate a table with a range of dates?
  11. Mysql: Select all data between two dates
  12. MySQL convert date string to Unix timestamp
  13. How to get difference between two dates in months using MySQL query?
  14. How to store a datetime in MySQL with timezone info
  15. Select mysql query between date?
  16. Datetime equal or greater than today in MySQL
  17. Group mysql query by 15 min intervals
  18. How to convert time to the time zone of the iPhone device?
  19. Select data between a date/time range
  20. How to get first day of every corresponding month in mysql?
  21. How to get the count of each distinct value in a column? [duplicate]
  22. Select all months within given date span, including the ones with 0 values
  23. Update date + one year in mysql
  24. mysql date comparison with date_format
  25. how to partition a table by datetime column?
  26. adding 1 day to a DATETIME format value
  27. How do I add two count(*) results together on two different tables?
  28. MySQL: Insert datetime into other datetime field
  29. MySQL: Find Missing Dates Between a Date Range
  30. How do I extract Month and Year in a MySQL date and compare them?

Leave a Comment