Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Creating Tables in SQL

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