Skip to content
Advertisement

How to insert date in SQL date type column?

I have a table with date type column.

enter image description here

I am trying to insert date in it:

enter image description here

But I get an error:

enter image description here

Please give me to make the correct query to put the date

Advertisement

Answer

Easy fix::

INSERT INTO t(dob) VALUES(DATE '2015-12-17');
User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement