date format

prams · Post by **prams** » Thu Oct 16, 2008 12:53 am

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

Scope · Post by **Scope** » Thu Oct 16, 2008 3:20 am

try to insert without any conversion

chulett · Post by **chulett** » Thu Oct 16, 2008 7:19 am

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').

prams · Post by **prams** » Thu Oct 16, 2008 8:24 am

Scope wrote:try to insert without any conversion

Thanks for reply