java yyyy-mm-dd hh24:mm:ss,Oracle中YYYY-MM-DD HH：MM：SS格式的时间戳转换

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

解决方案INSERT INTO AM_PROGRAM_TUNING_EVENT_TMP1

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