Dates are so much a part of everyday life that it becomes easy to work with them without thinking. However, the quirks of the Gregorian calendar can be difficult to work with in programs. Fortunately, PHP provides powerful tools for date arithmetic that make date manipulation an easy task. Similarly, MySQL comes with its own set of date-related functions. You learn about these in this hour as well, and find that MySQL can take a lot of the programming burden off your hands.
In this hour, you will learn
How to acquire the current date and time
How to get information about a date
How to format date information
How to test dates for validity
How to set dates
How to use MySQL's date and time-related functions
How to format date and time results in MySQL
How to find and express intervals between dates and times using MySQL