This content has been marked as final. Show 4 replies
How are you trying to load this data.
All database sessions can modify the expected date format, the form just depends on how you're trying to load
This may also help you
ALTER SESSION SET NLS_DATE_FORMAT = 'dd-mon-rr';
I am uploading the database script to APEX and then running them from there.
Any hint on what the script looks like?
If it's just a bunch of inserts, you probably have two options
1) Add the "alter session" at the top, as described
2) Use text editor to perform bulk update first
You should be explicitly converting the date in the script anyway so use
Replacing '01-JAN-2013' with whatever the date is. If there are a lot, some clever find and replacing in a text editor like Notepad ++ should sort it out.