DATE()

The DATE() function extracts just the date portion of a time string, which consists of the year, month, and day (YYYY-MM-DD).

Syntax

SELECT DATE('2022-09-01 17:38:22');
-- Result: 2022-09-01

Example

For example, suppose there’s a bodega table with the following data:

SELECT DATE(order_date),
   COUNT(*) AS 'count_baked_goods'
FROM bodega
GROUP BY DATE(order_date);

This would return the different dates from the order_date column and the total number of rows with each date: