insert date to column sql code example
Example 1: insert date sql
INSERT INTO FOO (xpto) VALUES(TO_DATE('17/12/2015', 'DD/MM/YYYY'));
Example 2: add colum date in sql
ALTER TABLE ADD COLUMN this_date DATE DEFAULT CURRENT_DATE;
INSERT INTO FOO (xpto) VALUES(TO_DATE('17/12/2015', 'DD/MM/YYYY'));
ALTER TABLE ADD COLUMN this_date DATE DEFAULT CURRENT_DATE;