月份: 2016-09

SQL LOADER 导入含有timestamp的数据

数据中的timestamp字段类似:
Tue Apr 09 18:24:26 CST 2016

LOAD DATA
INFILE ‘infile.dat’
TRUNCATE
INTO TABLE test01 FIELDS TERMINATED BY ‘,’
TRAILING NULLCOLS
(
“DOC_DATE_ADDED” TIMESTAMP WITH TIME ZONE “DY MON DD HH24:MI:SS TZR YYYY”,
)