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:
order_id | item | price | quantity | order_date |
---|---|---|---|---|
1 | Donut | 2.49 | 2 | 2022-08-16 08:04:23 |
2 | Cookie | 0.99 | 3 | 2022-08-16 09:43:00 |
3 | Donut | 2.49 | 1 | 2022-08-16 11:25:12 |
4 | Egg Sandwich | 7.99 | 1 | 2022-08-17 11:45:41 |
5 | Ice Coffee | 3.99 | 2 | 2022-08-17 12:18:50 |
SELECT DATE(order_date),COUNT(*) AS 'count_baked_goods'FROM bodegaGROUP BY DATE(order_date);
This would return the different dates from the order_date
column and the total number of rows with each date:
DATE(order_date) | count_baked_goods |
---|---|
2022-08-16 | 3 |
2022-08-17 | 2 |
Contributors
- Anonymous contributors