Archive for the ‘Oracle’ Category.

Oracle Insert Date

July 22, 2014, 9:47 pm

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'))
Tags: , , ,
Category: Oracle  |  Comment