# Import wizard issue with date in YYYYMMDD format **URL:** \ **Category:** Toad Data Point & Toad Intelligence Central\ **Created:** [February 9, 2012, 11:49am UTC](https://forums.toadworld.com/t/import-wizard-issue-with-date-in-yyyymmdd-format/7086 "2012-02-09T11:49:15Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![adolique\_968](https://avatars.discourse-cdn.com/v4/letter/a/bbce88/32.png) [@adolique\_968](https://forums.toadworld.com/u/adolique_968)\ **Post date:** [February 9, 2012, 11:49am UTC](https://forums.toadworld.com/t/import-wizard-issue-with-date-in-yyyymmdd-format/7086/1 "2012-02-09T11:49:15Z")
Value ‘20090729’ at row #218 cannot be convert to type TIMESTAMP(6) of column DATE\_EFFET When trying to import data in a YYYYMMDD format into a ‘TIMESTAMP’ type field in table from a csv file using the Import tool wizard, I always have an issue. Example: Could the import tool be enhanced to undestand that type of format. ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [February 9, 2012, 1:59pm UTC](https://forums.toadworld.com/t/import-wizard-issue-with-date-in-yyyymmdd-format/7086/2 "2012-02-09T13:59:12Z")
I nend to know what connection type you are using. If I can reproduce on this end I can enter a ticket. Please provide database type and version. And a smaple file wouldn’t hurt Debbie ---
**Author:** ![adolique\_968](https://avatars.discourse-cdn.com/v4/letter/a/bbce88/32.png) [@adolique\_968](https://forums.toadworld.com/u/adolique_968)\ **Post date:** [February 16, 2012, 7:49am UTC](https://forums.toadworld.com/t/import-wizard-issue-with-date-in-yyyymmdd-format/7086/3 "2012-02-16T07:49:54Z")
Hello, This occurs during an attempt of import to Oracle 10g or 11g. I am using Orace 11g client ODBC driver. Actully (it may be linked to my regional settings ?) only DD/MM/YYYY (HH24:MIS:SS) format is understood. Thank you for your help. Regards, Alexandre DOLIQUE. ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [February 16, 2012, 4:42pm UTC](https://forums.toadworld.com/t/import-wizard-issue-with-date-in-yyyymmdd-format/7086/4 "2012-02-16T16:42:59Z")
I did enter CR96341 for this enhancement. But I am not sure we would want to do this as there are many other formats that would also need to be supported. We test and verifiy that anything exported by TDA can be Imported by TDA. I would suggest as a work around to connect to this file(as csv or excel) and use SQL to format the way you want it. Use this SQL as a Query in Import to your Oracle destination database. Debbie ---
**Author:** ![adolique\_968](https://avatars.discourse-cdn.com/v4/letter/a/bbce88/32.png) [@adolique\_968](https://forums.toadworld.com/u/adolique_968)\ **Post date:** [February 20, 2012, 3:51am UTC](https://forums.toadworld.com/t/import-wizard-issue-with-date-in-yyyymmdd-format/7086/5 "2012-02-20T03:51:12Z")
Thank you for your reply. Actually the most flexible would be to be able to specify the date format in the import Wizzard (as it is done in a control file when using sqlldr). Regards, Alexandre DOLIQUE. ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [February 20, 2012, 5:18pm UTC](https://forums.toadworld.com/t/import-wizard-issue-with-date-in-yyyymmdd-format/7086/6 "2012-02-20T17:18:47Z")
That sounds reasonable. I will add that to the enhancement request. Debbie ---
**Author:** ![Joshua\_Tinashe](https://avatars.discourse-cdn.com/v4/letter/j/f14d63/32.png) [@Joshua\_Tinashe](https://forums.toadworld.com/u/Joshua_Tinashe)\ **Post date:** [November 19, 2016, 6:32am UTC](https://forums.toadworld.com/t/import-wizard-issue-with-date-in-yyyymmdd-format/7086/7 "2016-11-19T06:32:34Z")
Hello Debbie I’m a big TOAD fan by default! Anyway… I have a problem and I think maybe its one solved by this query. The bulk of what I want to do with Toad Data Point is importing CSV files into the database on a schedule. All the csv files have a date field. All the date fields on the CSV’s are either dd/mm/yyyy or dd-mm-yyyy. When I import using Toad for Oracle, there is an option under Dates, Times and Numbers, Dates Order - to use a custom format. How do I use that in the TOAD Data Point as this is essential to how we operate? Kind regards, Joshua