Comparing Date/Time Values

Creating, accessing, and modifying temporal values in MySQL covers many of the functions provided for date and time. However, the comparison remains a fourth use case for working with temporal values. By its very nature, comparisons of temporal values are especially common in an SQL statement’s WHERE clause: