APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Load CSV Data with Dates

765161Jun 11 2010 — edited Jun 11 2010

Hello All,

I have a CSV file and am trying to load it into an existing table and am having trouble loading dates into date columns. It has dates formatted like (31/12/2010 00:00:00) and the Apex data load will not accept them. It seems to only accept something like : 31/DEC/2010 00:00:00.

I can't reformat the CSV file as there are 42,000 rows of data. Is there some way to make this work? I see a format column in the data load screen, but haven't found any info on what this is or how to use it.
Any help would be greatly appreciated!

TIA
Mark

This post has been answered by TexasApexDeveloper on Jun 11 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 9 2010

Added on Jun 11 2010

#apex-discussions

4 comments

1,941 views