SQL-complete-tutorial

1
SELECT DATE_ADD(NOW(), INTERVAL 1 DAY);
2
SELECT DATE_ADD(NOW(), INTERVAL -1 DAY);
3

4
SELECT DATE_ADD(NOW(), INTERVAL 1 YEAR);
5
SELECT DATE_SUB(NOW(), INTERVAL 1 YEAR);
6

7
SELECT DATEDIFF('2019-01-05 09:00', '2019-01-01 17:00');
8
SELECT TIME_TO_SEC('09:00') - TIME_TO_SEC('09:02');