DSXchange

Hi All,

I have csv source file from that i am getting the date column in the format "dd-mon-yy" but, i need to load into oracle table in oracle table the data type is date.

i tried to use the insert query as to_date(string 'dd-mon-yy') but i am getting the aborted.

i tried to use the stringtodate function also now also it is aborting.

can any one help me in this regard

Thanks
Prams

try to insert without any conversion

Aborted how? What error? Your TO_DATE syntax looks fine as long as there's a comma in there: to_date(string, 'dd-mon-yy').

Scope wrote:try to insert without any conversion

Thanks for reply