SQL Developer date display format

Question

I am trying to change the date display format in SQL Developer, but even after setting NLS_DATE_LANGUAGE='ITALIAN' I get this:

select sysdate from dual; ==> 21 DECEMBER 18 (wrong, still in English)

select to_char(sysdate,'DD MONTHYYYY') from dual; ==> 21 DICEMBRE 2018 (Italian, correct)

There is some different parameter I need to set elsewhere? Thank you

you can try this , select to_char(sysdate, 'dd Month, Day', 'NLS_DATE_LANGUAGE = ITALIAN') from dual — Aishwarya
– Aishwarya, Commented Dec 21, 2018 at 12:15

sticky bit · Accepted Answer · 2018-12-23 03:00:46Z

2

Try if the following works for you.

In the menu bar click on "Tools" and choose "Preferences". Expand the node "Database" and click on the sub node "NLS". Set "Date Language" to "ITALIAN" there. Click the "OK" button.

answered Dec 23, 2018 at 3:00

sticky bit

37.7k12 gold badges34 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Developer date display format

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related