Timestamp conversion in Oracle for YYYY-MM-DD HH:MM:SS format

Question

I'm trying to insert records with YYYY-MM-DD HH:MM:SS format into Oracle from Netezza, but I'm getting invalid date type.

How can I accomplish this one?

CREATE TABLE AM_PROGRAM_TUNING_EVENT_TMP1
(
    ST TIMESTAMP,
    ET TIMESTAMP,
    MAS_DIV_KEY INTEGER NOT NULL,
    SBSC_GUID_KEY INTEGER NOT NULL,
    STN_KEY INTEGER NOT NULL
 );


INSERT INTO  AM_PROGRAM_TUNING_EVENT_TMP1 VALUES('2012-03-28 11:10:00','2012-03-28 11:30:00',1,3636815,151);

Please post the INSERT statement you're using, the DDL for your table, and an example of the data. — Bob Jarvis - Слава Україні, Apr 25 '12 at 16:36
My data is coming from a flat file... and I want to perform date transformation while inserting data... — Teja, Apr 25 '12 at 16:42

hkutluay · Answer 1 · 2017-02-08T15:05:10.607

31

Use TO_TIMESTAMP function

TO_TIMESTAMP(date_string,'YYYY-MM-DD HH24:MI:SS')

edited Feb 08 '17 at 15:05

answered Apr 25 '12 at 16:37

hkutluay

6,794
2
33
53

score 18 · Accepted Answer · edited Nov 25 '13 at 06:20

18

INSERT INTO AM_PROGRAM_TUNING_EVENT_TMP1 
VALUES(TO_DATE('2012-03-28 11:10:00','yyyy/mm/dd hh24:mi:ss'));

http://www.sqlfiddle.com/#!4/22115/1

edited Nov 25 '13 at 06:20

hkutluay

6,794
2
33
53

answered Apr 25 '12 at 16:42

aquinas

23,318
5
58
81

Timestamp conversion in Oracle for YYYY-MM-DD HH:MM:SS format

2 Answers2

Linked