SQL-complete-tutorial

1
SELECT NOW(), CURDATE(), CURTIME();
2
SELECT YEAR(NOW());
3
SELECT MONTH(NOW());
4
SELECT DAY(NOW());
5
SELECT HOUR(NOW());
6
SELECT MINUTE(NOW());
7
SELECT DAYNAME(NOW());
8
SELECT MONTHNAME(NOW());
9
SELECT EXTRACT(DAY FROM NOW());
10
SELECT EXTRACT(YEAR FROM NOW());
11

12
SELECT * 
13
FROM orders
14
WHERE order_date >= '2019-01-01';
15

16
SELECT * 
17
FROM orders
18
WHERE YEAR(order_date) = YEAR(NOW());