I am trying to import a CSV file from a prospect, they are moving data from Oracle 12c and export a dataset with following dates using meridian format.
Some example dates are:
29/07/2017 09:18:39 a.m.
01/08/2017 10:27:49 a.m.
01/08/2017 09:20:39 p.m.
I have tried to import it using mongoimport with .date_oracle, with several formats and none is working:
FECHA_APERTURA.date_oracle(DD/MM/YYYY HH:MI:SS AM)
FECHA_APERTURA.date_oracle(DD/MM/YYYY HH12:MI:SS AM)
If I run it, then I get following error message:
Failed: type coercion failure in document #0 for column ‘FECHA_APERTURA’, could not parse token ‘29/07/2017 09:18:39 a.m.’ to type date_oracle
I am using MongoDB 3.6.6 Enterprise Advanced on Mac OS Sierra (10.12.6)
What am I doing wrong? Is this format supported?