sql insert date column 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;