how to insert datetime in sql code example
Example 1: insert date sql
INSERT INTO FOO (xpto) VALUES(TO_DATE('17/12/2015', 'DD/MM/YYYY'));Example 2: add time to date sql
ADDTIME(NOW(),'5:30:00')INSERT INTO FOO (xpto) VALUES(TO_DATE('17/12/2015', 'DD/MM/YYYY'));ADDTIME(NOW(),'5:30:00')