Skip to Main Content

SQL Developer

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!

Import from CSV date masks

Oscar ValdezMay 11 2022

I'm importing date+time data from CSV files, and the import wizard doesn't warn about the data while proposing this format: "YYYY-MM-DD:HH24:MI:SS", when the proper format should be: "DD/MM/RRRR HH24:MI".
Why does the wizard not warn about the data with the proposed "YYYY-MM-DD:HH24:MI:SS" format?

Comments

thatJeffSmith-Oracle

I dunno, it sounds like a bug to me.
Can you share two lines of your CSV data that demonstrates the issue and I can take a look, assuming you're on latest of SQLDev (21.4.3)

Oscar Valdez

I'm on version 21.4.2.
medidor,CicloDesc,FechaHora,KWH,KW,KVA,KVAR
5284288,202203,24/02/2022 23:15,73.656,294.624,318.6706371,121.44
5284288,202203,24/02/2022 23:30,77.902,311.608,338.1392986,131.296

thatJeffSmith-Oracle

We do our best to detect...

you can override our advice with the proper date function call format, which in this case would be
'DD/MM/YYYY HH24:MI'

Oscar Valdez

Gracias!

1 - 4

Post Details

Added on May 11 2022
4 comments
956 views