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.

Stuck? Here's a hint!

Type

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

Console

Code editor

Result

TableConsole