| 14. 11. DATE_FORMAT |
| 14. 11. 1. | DATE_FORMAT() | | |
| 14. 11. 2. | Dates can also be formatted in 'plain english' | | |
| 14. 11. 3. | Using DATE_FORMAT() with an alias to tidy up the title | | |
| 14. 11. 4. | %a: Abbreviated weekday name (Sun..Sat) | | |
| 14. 11. 5. | %b: Abbreviated month name (Jan..Dec) | | |
| 14. 11. 6. | %c: Month, numeric (0..12) | | |
| 14. 11. 7. | %D: Day of the month with English suffix (0th, 1st, 2nd, 3rd, ...) | | |
| 14. 11. 8. | %d: Day of the month, numeric (00..31) | | |
| 14. 11. 9. | %e: Day of the month, numeric (0..31) | | |
| 14. 11. 10. | %f: Microseconds (000000..999999) | | |
| 14. 11. 11. | %H: Hour (00..23) | | |
| 14. 11. 12. | %h: Hour (01..12) | | |
| 14. 11. 13. | %I: Hour (01..12) | | |
| 14. 11. 14. | %i: Minutes, numeric (00..59) | | |
| 14. 11. 15. | %j: Day of year (001..366) | | |
| 14. 11. 16. | %k: Hour (0..23) | | |
| 14. 11. 17. | %l: Hour (1..12) | | |
| 14. 11. 18. | %M: Month name (January..December) | | |
| 14. 11. 19. | %m: Month, numeric (00..12) | | |
| 14. 11. 20. | %p: AM or PM | | |
| 14. 11. 21. | %r: Time, 12-hour (hh:mm:ss followed by AM or PM) | | |
| 14. 11. 22. | %S: Seconds (00..59) | | |
| 14. 11. 23. | %T: Time, 24-hour (hh:mm:ss) | | |
| 14. 11. 24. | %U: Week (00..53), where Sunday is the first day of the week | | |
| 14. 11. 25. | %u: Week (00..53), where Monday is the first day of the week | | |
| 14. 11. 26. | %V: Week (01..53), where Sunday is the first day of the week; used with %X | | |
| 14. 11. 27. | %v: Week (01..53), where Monday is the first day of the week | | |
| 14. 11. 28. | %W: Weekday name (Sunday..Saturday) | | |
| 14. 11. 29. | %w: Day of the week (0=Sunday..6=Saturday) | | |
| 14. 11. 30. | %X: Year for the week where Sunday is the first day of the week, numeric, four digits | | |
| 14. 11. 31. | %x: Year for the week, where Monday is the first day of the week, numeric, four digits | | |
| 14. 11. 32. | %Y: Year, numeric, four digits | | |
| 14. 11. 33. | %y: Year, numeric (two digits) | | |
| 14. 11. 34. | %%: A literal '%' character | | |
| 14. 11. 35. | SELECT DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y'); | | |
| 14. 11. 36. | SELECT DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s'); | | |
| 14. 11. 37. | SELECT DATE_FORMAT('1997-10-04 22:23:00','%D %y %a %d %m %b %j'); | | |
| 14. 11. 38. | SELECT DATE_FORMAT('1997-10-04 22:23:00','%H %k %I %r %T %S %w'); | | |
| 14. 11. 39. | SELECT DATE_FORMAT('1999-01-01', '%X %V'); | | |
| 14. 11. 40. | SELECT DATE_FORMAT('2006-06-00', '%d'); | | |