benjamindba
Thursday, November 3, 2011
date format in oracle loader
start_date TIMESTAMP "Mon dd yyyy hh:mi:ss:ff3AM",
select to_char(systimestamp,'Mon-dd-yyyy hh:mi:ss:ff3AM') from dual;
reference:
http://www.dbforums.com/oracle/1118058-sql-loader-date-format-unrecognized.html
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment