Date Math

1. SELECT * FROM people;
2.  
3. SELECT DATEDIFF(NOW(), birthdate) FROM people;
4.  
5. SELECT name, birthdate, DATEDIFF(NOW(), birthdate) FROM people;
6.  
7. SELECT birthdt FROM people;
8.  
9. SELECT birthdt, DATE_ADD(birthdt, INTERVAL 1 MONTH) FROM people;
10.  
11. SELECT birthdt, DATE_ADD(birthdt, INTERVAL 10 SECOND) FROM people;
12.  
13. SELECT birthdt, DATE_ADD(birthdt, INTERVAL 3 QUARTER) FROM people;
14.  
15. SELECT birthdt, birthdt + INTERVAL 1 MONTH FROM people;
16.  
17. SELECT birthdt, birthdt - INTERVAL 5 MONTH FROM people;
18.  
19. SELECT birthdt, birthdt + INTERVAL 15 MONTH + INTERVAL 10 HOUR FROM people;