Skip to Main Content
Forums

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!

Understanding date format in Apex - Data Load Pages

M.EmmanuelAug 18 2016 — edited Aug 19 2016

I have a table with a DATE datatype field:

pastedImage_1.png

I am trying to import rows with the following format (DD/MM/YYYY):

pastedImage_0.png

And I am getting the following error ORA-01843:

pastedImage_2.png

Could someone help me to understand into what the date should be formatted and how could that be done in Apex?

What if I change user language and localization to an European one (where date is DD/MM/YYYY)?

Thanks,
This post has been answered by M.Emmanuel on Aug 18 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 16 2016
Added on Aug 18 2016
#apex-discussions
5 comments
2,600 views