Hi All,
Am trying to import a date column from a csv file.
When creating the csv file I check if the date if empty so I can create an empty value.
If is empty I create use this '00/00/0000'
If there is a date I use the same value but I convert it to a char field like this '01/02/2020' so am sending a char column in both situations.
The problem is that when I import the table to oracle using the Data Loading Page of APEX
the empty dates are recognize as '00/00/0000' while the not empty dates are formatted as '01-FEB-2020' Both varchar2.
so when converting that field with TO_DATE(field ,'MM/DD/YYYY') function I get an error.
Any ideas how can I work this?
Thanks for the help!