SQL Date Tutorial - Interactive Database Lesson

Date

Interactive SQL Tutorial

Sometimes, a column can contain a date value. The first 4 digits represents the year, the next 2 digits represents the month, and the next 2 digits represents the day of the month. For example, 1985-07-20 would mean July 20, 1985.

You can compare dates by using < and >. For example, SELECT * FROM celebs_born WHERE birthdate < '1985-08-17'; returns a list of celebrities that were born before August 17th, 1985.

Can you return a list of celebrities that were born after September 1st, 1980?

SQL:

SQL Date Tutorial - Interactive Database Lesson

Lessons

Date

Query Result:

Available Tables:

Expected Result: