How to Count Records Within a Date-Time Interval in MySQL?

Finding Record Counts within Date-Time Intervals in MySQL

You're facing a difficulty in retrieving record counts that fall within a specific date-time range in a MySQL database. Specifically, you have a column named 'created' that contains timestamps and you seek to count records created between "TODAY'S 4:30 AM" and "CURRENT DATE TIME."

To solve this issue, you can utilize the following MySQL functions:

Using 'BETWEEN' Operator:

SELECT count(*) FROM `table` 
WHERE 
    created_at BETWEEN '2023-03-17 04:30:00' AND '2023-03-17 07:42:50';

Replace the hardcoded dates with the variables or expressions representing "TODAY'S 4:30 AM" and "CURRENT DATE TIME."

Using '>' and '<' Operators:

SELECT count(*) FROM `table` 
WHERE 
    created_at > '2023-03-17 04:30:00' AND created_at < '2023-03-17 07:42:50';<p>Again, modify the date values to match your requirements.</p>
<p><strong>Using 'CURDATE()' and 'NOW()' Functions:</strong></p>
<p>To retrieve the current date and time, you can use the following functions:</p>
<pre class="brush:php;toolbar:false">SELECT count(*) FROM `table` 
WHERE 
    created_at BETWEEN CURDATE() + INTERVAL '04:30:00' HOUR AND NOW();

This query counts records created after "TODAY'S 4:30 AM" and before the current moment.

By adjusting the date and time values as needed, you can obtain the desired record counts within the specified date-time interval.

The above is the detailed content of How to Count Records Within a Date-Time Interval in MySQL?. For more information, please follow other related articles on the PHP Chinese website!