Section 5.1. Introduction
Section 5.2. Changing MySQL's Date Format
Section 5.3. Telling MySQL How to Display Dates or Times
Section 5.4. Determining the Current Date or Time
Section 5.5. Decomposing Dates and Times Using Formatting Functions
Section 5.6. Decomposing Dates or Times Using Component-Extraction Functions
Section 5.7. Decomposing Dates or Times Using String Functions
Section 5.8. Synthesizing Dates or Times Using Formatting Functions
Section 5.9. Synthesizing Dates or Times Using Component-Extraction Functions
Section 5.10. Combining a Date and a Time into a Date-and-Time Value
Section 5.11. Converting Between Times and Seconds
Section 5.12. Converting Between Dates and Days
Section 5.13. Converting Between Date-and-Time Values and Seconds
Section 5.14. Adding a Temporal Interval to a Time
Section 5.15. Calculating Intervals Between Times
Section 5.16. Breaking Down Time Intervals into Components
Section 5.17. Adding a Temporal Interval to a Date
Section 5.18. Calculating Intervals Between Dates
Section 5.19. Canonizing Not-Quite-ISO Date Strings
Section 5.20. Calculating Ages
Section 5.21. Shifting Dates by a Known Amount
Section 5.22. Finding First and Last Days of Months
Section 5.23. Finding the Length of a Month
Section 5.24. Calculating One Date from Another by Substring Replacement
Section 5.25. Finding the Day of the Week for a Date
Section 5.26. Finding Dates for Days of the Current Week
Section 5.27. Finding Dates for Weekdays of Other Weeks
Section 5.28. Performing Leap Year Calculations
Section 5.29. Treating Dates or Times as Numbers
Section 5.30. Forcing MySQL to Treat Strings as Temporal Values
Section 5.31. Selecting Records Based on Their Temporal Characteristics
Section 5.32. Using TIMESTAMP Values
Section 5.33. Recording a Row's Last Modification Time
Section 5.34. Recording a Row's Creation Time
Section 5.35. Performing Calculations with TIMESTAMP Values
Section 5.36. Displaying TIMESTAMP Values in Readable Form
