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

Data Types in SQL

Introduction
Boolean
Date and time
6. Date – inserting data
Summary

Instruction

As you can see, dates are stored in the format YYYY-MM-DD. Not very complicated, huh? Just keep in mind that you need to put apostrophes (single quotes) around each date!

Exercise

For Peter, Valentine's Day is an important holiday. Let's put the date Feb 14, 2019 into the table holiday. To escape the apostrophe in Valentine's Day, write:

'Valentine''s Day'