Date functions help you work with dates and times in SQL. Essential for reporting and time-based analysis.

Current Date/Time

SELECT NOW(); -- Current datetime

SELECT CURDATE(); -- Current date

SELECT CURTIME(); -- Current time

Extract Date Parts

SELECT YEAR(order_date) as year FROM orders;

SELECT MONTH(order_date) as month FROM orders;

SELECT DAY(order_date) as day FROM orders;

Date Formatting

SELECT DATE_FORMAT(order_date, '%Y-%m-%d') FROM orders;

SELECT DATE_FORMAT(order_date, '%M %d, %Y') FROM orders;

Date Arithmetic

SELECT DATE_ADD(NOW(), INTERVAL 7 DAY);

SELECT DATE_SUB(NOW(), INTERVAL 1 MONTH);

SELECT DATEDIFF('2025-12-31', '2025-01-01');

Date Comparisons

SELECT * FROM orders WHERE order_date >= DATE_SUB(NOW(), INTERVAL 30 DAY);

SELECT * FROM orders WHERE YEAR(order_date) = 2025;

Group by Date

SELECT DATE(created_at), COUNT(*)

FROM orders

GROUP BY DATE(created_at);

Generate Date Queries

AI2sql handles date logic automatically.