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';

Console

Code editor

Result

TableConsole