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
34. Date - inserting data
Summary

Instruction

Okay, as you can see, dates are stored as yyyy-MM-dd. Not very complicated, huh? Just keep in mind that you need to put apostrophes around each date!

Exercise

For Peter, the Valentine's Day is an important holiday. Let's put the date 14 Feb 2016 into the table holiday.

To escape an apostrophe in Valentine's Day, you can write:

'Valentine''s Day'

Stuck? Here's a hint!

Type

INSERT INTO holiday VALUES ('Valentine''s Day', '2016-02-14');