Archive for the Category: Oracle

Oracle Insert Date

A simple SQL example of using the To_Date function to format a date. INSERT INTO EXAMPLETBL (EXAMPLEID, EXAMPLEDATE) VALUES (‘5’, TO_DATE(‘2014-05-08 08:06:24’, ‘YYYY-MM-DD HH24:MI:SS’))

Tagged , , , Leave a comment