Skip to Main Content
Forums

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 Data from Excel file DateTime format problem

281c6d2f-c636-4bb9-928f-b0983dc2a047Oct 8 2015 — edited Oct 9 2015

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 6 2015
Added on Oct 8 2015
#sql-developer, #sqldeveloper
7 comments
10,138 views