Hie, I just need a small help here..
I have written this control file but then I want to truncate the dates but Im not sure how to do it
Hope anyone can help..
APPEND INTO TABLE trap_stage_ppb
FIELDS TERMINATED BY ','
CREATE_DATE DATE "yyyymmddhh24miss",
DELIVERED_DATE DATE "yyyymmddhh24miss",
UNITS ":units / 100",
DEFERRED_DATE DATE "yyyymmddhh24miss",
DATE_MOD "(SELECT trunc(sysdate) FROM dual)"
this is how the data looks like
brother.. i tried in many many ways and thats why i posted it here...
if u say im lazy, i think posting it here and waiting for ur answer is wasting more of my time... ITS just that I cant get it and thats why im asking
maybe u can help or at least give me the proper link...
if u feel, its troublesome for you to show me by just adding 2-3 words in the control file, then its okies... maybe someone who knows will help...