MySQL: How to Select Rows where Date is Equal to Today


You can use the following basic syntax in MySQL to return all rows in a table where the date in a date column is equal to today:

SELECT *
FROM sales
WHERE DATE(sales_date) = CURDATE();

This particular example selects all rows in the table named sales where the date in the sales_date column is equal to today’s date.

Note: The CURDATE() function in MySQL returns the current date.

The following example shows how to use this syntax in practice.

Example: How to Select Rows where Date is Equal to Today in MySQL

Suppose we have the following table named sales that contains information about sales made at various grocery stores at various times:

-- create table 
CREATE TABLE sales (
  store_ID INT PRIMARY KEY,
  item TEXT NOT NULL,
  sales_date DATETIME NOT NULL
);

-- insert rows into table
INSERT INTO sales VALUES (0001, 'Oranges', '2024-02-12 03:45:00');
INSERT INTO sales VALUES (0002, 'Apples', '2020-11-25 15:25:01');
INSERT INTO sales VALUES (0003, 'Bananas', '2009-06-30 09:01:39');
INSERT INTO sales VALUES (0004, 'Melons', '2024-02-12 03:29:55');
INSERT INTO sales VALUES (0005, 'Grapes', '2023-05-19 23:10:04');

-- view all rows in table
SELECT * FROM sales;

Output:

+----------+---------+---------------------+
| store_ID | item    | sales_date          |
+----------+---------+---------------------+
|        1 | Oranges | 2024-02-12 03:45:00 |
|        2 | Apples  | 2020-11-25 15:25:01 |
|        3 | Bananas | 2009-06-30 09:01:39 |
|        4 | Melons  | 2024-02-12 03:29:55 |
|        5 | Grapes  | 2023-05-19 23:10:04 |
+----------+---------+---------------------+

This article is currently being written on 2/12/2024.

Suppose that we would like to select all rows where the date in the sales_date column is equal to today’s date.

We can use the following syntax to do so:

SELECT *
FROM sales
WHERE DATE(sales_date) = CURDATE();

Output:

+----------+---------+---------------------+
| store_ID | item    | sales_date          |
+----------+---------+---------------------+
|        1 | Oranges | 2024-02-12 03:45:00 |
|        4 | Melons  | 2024-02-12 03:29:55 |
+----------+---------+---------------------+

Notice that each of the rows in the resulting table have a date in the sales_date column that is equal to today’s date of 2/12/2024.

Note: We used the DATE function to extract only the date from the datetimes in the sales_date column to compare it to today’s date.

Additional Resources

The following tutorials explain how to perform other common tasks in MySQL:

MySQL: How to Insert Date
MySQL: How to Return All Rows Between Two Dates
MySQL: How to Return All Rows Greater Than Date

Leave a Reply

Your email address will not be published. Required fields are marked *