Convert timestamp to Oracle for YYYY-MM-DD HH: MM: SS format

Question

I am trying to insert records with the format YYYY-MM-DD HH:MM:SS in Oracle from Netezza, but I am getting an invalid date type.

How can I accomplish this?

 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); 

Answer 1

 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

Answer 2

Use the TO_TIMESTAMP Function

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