SQL & PL/SQL

Hello,

I wan't to question how to convert epoch time to datetime in sql*loader Oracle. I try this script for convert epoch time to datetime in sql*loader, but error:

Record 1: Rejected - Error on table TEMP_TEST_LANGY, column DATADATA.
ORA-01722: invalid number

Record 2: Rejected - Error on table TEMP_TEST_LANGY, column DATADATA.
ORA-01722: invalid number

Record 3: Rejected - Error on table TEMP_TEST_LANGY, column DATADATA.
ORA-01722: invalid number


This is my loader:

LOAD DATA INFILE 'C:\Documents and Settings\Administrator\My Documents\XL_EXTRACT_211\load.csv'
into table TEMP_TEST_LANGY append
FIELDS TERMINATED BY ','
TRAILING NULLCOLS
(
DATADATA CHAR "TO_DATE('01-JAN-1970','DD-MON-YYYY')+:datadata/86400"
)

This is my csv file:

79314313.7066667
79314336.2933333
79314214.3466667

This is my table:

CREATE TABLE TEMP_TEST_LANGY
(
DATADATA DATE
)


Thanks

Edited by: xoops on Sep 21, 2011 8:56 AM

Edited by: xoops on Sep 21, 2011 8:58 AM