Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 437 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
date/time format in xlsx export

Using "Version 20.2.0.175/Build 175.1842".
I use nls_date_format = 'DD.MM.YYYY HH24:MI:SS'.
When exporting to xlsx, the time information in MS-Excel is gone and the date-format shown is "MM.DD.YY" (the time information is not hidden by the cell-format, but is really missing!)
e.g. SQLDeveloper: "31.01.2021 13:41:59" => MS-Excel: "01.31.2021"
As I was not able to solve this issue, I copied " Version 20.4.1.407/Build 407.0006" in parallel without migrating the config from my 10.2 version.
I use the same nls_date_format = 'DD.MM.YYYY HH24:MI:SS'.
When exporting "31.01.2021 13:41:59" to xlsx, I see "1.31.2021 1:41 PM" in MS-Excel (seconds are there, but only hidden by the cell-format).
=> is the date/time-format used in xlsx-export a configuration/setting in SQLDeveloper or fixed in the respective SQLDeveloper version?
Answers
-
This is working for me... 20.4.1, using your date format, using latest excel
-
thanks for your response!
but can you configure the date/time output format in SQLDeveloper, which is used in excel?
-
Just to_char your dates, use exactly whatever format you want, and you'll see what you want in Excel.
-
thanks!
It's clear, that the to_char-string is shown as defined:
select to_char(mydate,'DD.MM.YYYY HH24:MI:SS') to_char_date, mydate std_date from (select to_date(sysdate) mydate from dual);
SQLDeveloper
Excel
-> but my initial question was not related to exporting a string, but a date ...
=> is the date/time-format used in xlsx-export a configuration/setting in SQLDeveloper or fixed in the respective SQLDeveloper version?