Issue with Date Column

Bram · Post by **Bram** » Tue May 31, 2005 2:03 pm

HI ,

I am extracting the data from csv file, which has two date columns. Date is in format MM/DD/YYYY HH:MI:S (07/01/2204 00:00:00). I want to load that data into Oracle table, i dont mind whatever the date format in oracle.

Please advise me how to do that,

Thanks,
Ram

chulett · Post by **chulett** » Tue May 31, 2005 2:57 pm

There's been quite a few posts on the subject of handling Oracle DATE fields that a search will turn up. This one for example. Read throught it, search for some other posts (oracle and timestamp as keywords seemed to work well ) and then let us know if you have any other questions.