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

    Import Data from Excel file DateTime format problem

    281c6d2f-c636-4bb9-928f-b0983dc2a047

      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.

       

      02/05/2015


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

      Thanks.

      have a nice day.