Chapter 6. Working with Dates and Times

Section 6.0.  Introduction

Recipe 6.1.  Choosing a Temporal Data Type

Recipe 6.2.  Changing MySQL's Date Format

Recipe 6.3.  Setting the Client Time Zone

Recipe 6.4.  Determining the Current Date or Time

Recipe 6.5.  Using TIMESTAMP to Track Row Modification Times

Recipe 6.6.  Extracting Parts of Dates or Times

Recipe 6.7.  Synthesizing Dates or Times from Component Values

Recipe 6.8.  Converting Between Temporal Data Types and Basic Units

Recipe 6.9.  Calculating the Interval Between Two Dates or Times

Recipe 6.10.  Adding Date or Time Values

Recipe 6.11.  Calculating Ages

Recipe 6.12.  Shifting a Date-and-Time Value to a Different Time Zone

Recipe 6.13.  Finding the First Day, Last Day, or Length of a Month

Recipe 6.14.  Calculating Dates by Substring Replacement

Recipe 6.15.  Finding the Day of the Week for a Date

Recipe 6.16.  Finding Dates for Any Weekday of a Given Week

Recipe 6.17.  Performing Leap Year Calculations

Recipe 6.18.  Canonizing Not-Quite-ISO Date Strings

Recipe 6.19.  Treating Dates or Times as Numbers

Recipe 6.20.  Forcing MySQL to Treat Strings as Temporal Values

Recipe 6.21.  Selecting Rows Based on Their Temporal Characteristics