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