I am working on a project that involves importing data via Apex's data workshop. Two of my columns contain dates in the format YYYY-MM-DD HH:MI:SS. Can anyone tell me how to get Apex to import these columns correctly.

  • Have you looked at the TO_DATETIME('My_String', 'My_Format_String'). Something like TO_DATETIME('2014-10-05 15:23:56', 'YYYY-MM-DD HH:MI:SS') should work - note: not tested - don't have Oracle running here. Check the links here and here – Vérace Oct 5 '14 at 18:56
  • where would the date_time function go...in first row of the csv or in the format field of the name mapping screen of the data upload wizard – Brian Oct 5 '14 at 19:10
  • I'm afraid that I don't know how Apex's data workshop functions - I have a feeling that it's the mapping bit. Take a look at this which may help. If you don't get assistance here, you could try the Oracle Apex forums? – Vérace Oct 5 '14 at 23:10
  • Apex is a development tool; this is a development question and belongs on Stack Overflow. – Colin 't Hart Oct 15 '14 at 8:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.