It's Autumn! Prices fall like leaves! - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Boolean
Date and time
35. Date - comparing dates
Summary

Instruction

Excellent. Now, as you may expect, logical operators can be used to compare dates. For example:

SELECT * FROM holiday WHERE day < '2010-01-01';

The above query will select all holidays before 2010.

Exercise

In the table holiday, select all the information for all the holidays which happened after 1 Jan 2012.

Stuck? Here's a hint!

Type

SELECT * FROM holiday WHERE day > '2012-01-01';