MySQL Tutorials - Herong's Tutorial Examples - v4.46, by Herong Yang
Date and Time Operations
This section provides a list of date and time operations supported by SQL and some examples.
The most commonly used date and time operations are:
DATE '1999-01-01' + INTERVAL '3' MONTH DATE '2000-03-01' - INTERVAL '1' DAY -- watch out leap years! INTERVAL '48' HOUR + TIMESTAMP '1999-01-01 00:00:00'
Table of Contents