I have a CSV export from another tool. I'm trying to use the table -> import feature but I'm having an issue with the timestamp format.
select to_timestamp('Mon Jul 24 00:00:30 CDT 2017', '"Mon" MON DD HH24:MI:SS "CDT" YYYY') from dual:
This works in SQL. This also works if I run the subsequent script file that is presented after the import fails. Example, the following is the insert and the failure message, but this insert works if I run this file as a script.
INSERT INTO JDBC_METRICS (OWNER, NAME, TIME, VALUE) VALUES ('someValue','PercentUsed',to_timestamp('Mon Jul 24 00:00:30 CDT 2017', '"Mon" MON DD HH24:MI:SS "CDT" YYYY'),0.0);
--Insert failed for row 2
--TIME GDK-05021: date format not recognized
--Row 2
Is there a format I can use in the import utility for this to work?
Thanks.
Message was edited by: unleashed Correct format mask for year.
Message was edited by: unleashed
Change metric owner to protect the name.