Formatting dates

1. SELECT name, birthdate FROM people;
2.  
3. SELECT name, DAY(birthdate) FROM people;
4.  
5. SELECT name, birthdate, DAY(birthdate) FROM people;
6.  
7. SELECT name, birthdate, DAYNAME(birthdate) FROM people;
8.  
9. SELECT name, birthdate, DAYOFWEEK(birthdate) FROM people;
10.  
11. SELECT name, birthdate, DAYOFYEAR(birthdate) FROM people;
12.  
13. SELECT name, birthtime, DAYOFYEAR(birthtime) FROM people;
14.  
15. SELECT name, birthdt, DAYOFYEAR(birthdt) FROM people;
16.  
17. SELECT name, birthdt, MONTH(birthdt) FROM people;
18.  
19. SELECT name, birthdt, MONTHNAME(birthdt) FROM people;
20.  
21. SELECT name, birthtime, HOUR(birthtime) FROM people;
22.  
23. SELECT name, birthtime, MINUTE(birthtime) FROM people;
24.  
25. SELECT CONCAT(MONTHNAME(birthdate), ' ', DAY(birthdate), ' ', YEAR(birthdate)) FROM people;
26.  
27. SELECT DATE_FORMAT(birthdt, 'Was born on a %W') FROM people;
28.  
29. SELECT DATE_FORMAT(birthdt, '%m/%d/%Y') FROM people;
30.  
31. SELECT DATE_FORMAT(birthdt, '%m/%d/%Y at %h:%m') FROM people;