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”,
)

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>