7 Replies Latest reply on Oct 9, 2015 2:54 PM by thatJeffSmith-Oracle

    Import Data from Excel file DateTime format problem


      Hello, Dear Colleagues.

      Help me please to deal with the next problem.

      I have Excel file with field of Custom format 'dd.mm.yyyy hh:mm:ss'


      05.02.2015  17:55:06


      When I'm trying to import data through Oracle SQL Developer, choose appropriate Excel file, field already represented in format 'mm/dd/yyyy'

      and hh:mm:ss part is not shown.



      How to import data in format of 'dd.mm.yyyy hh:mm:ss' from Excel file?


      have a nice day.