A great god for help... Can't make out
Data given
The Create Date: 20170223
The Create Time: 181610
Use sqlloader format need to be plugged into the database. This appearance of the 2017-02-23 18:16:10 001
My writing... Can't try for a variety of distress
(
CreateDate BOUNDFILLER Position (47:54) date "yyyymmdd",
CreateTime BOUNDFILLER Position (! 0) date "hh24: mi: as,"
Create_DT_TM ": the CreateDate | |" | | : CreateTime "
)

CodePudding user response:

If worry
Load the varchar2 format data first, transformation to the data list again,

CodePudding user response:

Here is saved in the database varchar2 format, the problem is not cut in, should be to write a question...