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

Determining Record Count within a Date-Time Range in MySQL

In MySQL, retrieving the count of records that fall within a specific date-time range can be a common task. This article addresses this issue by offering a clear solution based on the user's query.

The user's objective is to acquire the count of records in a table named 'table' that have a 'created' column of datetime data type. The user wants to count records created between "TODAY'S 4:30 AM" and "CURRENT DATE TIME."

To achieve this, we can utilize the '>' (greater than) and '<=' (less than or equal to) operators in the WHERE clause. The following query demonstrates how:

SELECT COUNT(*) FROM `table` WHERE created_at > 'DATE_TIME_START' AND created_at <= 'DATE_TIME_END';</p>
<p>Replace 'DATE_TIME_START' with "TODAY'S 4:30 AM" in the datetime format, and 'DATE_TIME_END' with "CURRENT DATE TIME" in the datetime format. Alternatively, you can use the CURDATE() or NOW() functions to obtain the current date or time and construct the query dynamically.</p>
<p>Another approach is to employ the BETWEEN operator within the WHERE clause, as shown below:</p>
<pre class="brush:php;toolbar:false">SELECT COUNT(*) FROM `table` WHERE created_at BETWEEN 'DATE_TIME_START' AND 'DATE_TIME_END';

By implementing these queries, you can effectively determine the count of records created within the specified date-time range in your MySQL database.

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