Introduction
Boolean
Date and time
33. Date
Summary

Instruction

Excellent! The last group of data types we're going to learn are types used to store time.

Let's start with the data type called date.

Exercise

We've got a very simple table called holiday which stores information about national holidays in a given year. It has two columns: name and day. Let's select the columns name and day for all rows to see how dates are stored in SQL.

Stuck? Here's a hint!

Type

SELECT name, day FROM holiday;

Console

Code editor

Result

TableConsole