Link to home
Start Free TrialLog in
Avatar of Ivo Raemy
Ivo Raemy

asked on

How to change in "Oracle SQL Developer Version 19" the date format in "export to excel"?

When I export in "Oracle SQL Developer Version 19" data to excel 2003+, SQL Developer sets the date format "M.T.JJJJ h:mm AM/PM"

How can I change that SQL Developer exports date in format "TT.MM.JJJJ hh:mm"?
Avatar of HainKurt
HainKurt
Flag of Canada image

check the settings...
there should be some settings for NLS date/time formatting...
something like below


User generated image

Avatar of Ivo Raemy
Ivo Raemy

ASKER

I have, but the format is  "5.23.2019 10:20 AM"
User generated image
looks like it is exported as correct date
excel shows it in different format
check the format of that column in excel, and change whatever you want...
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.