Home » SQL & PL/SQL » Client Tools » SQL Developer 3 - NLS settings not working (Version 3.1.07 Build MAIN-07.42 Windows 7)
SQL Developer 3 - NLS settings not working [message #649166] Tue, 15 March 2016 11:25 Go to next message
doug8294
Messages: 7
Registered: November 2011
Junior Member
I am using sql developer Version 3.1.07 Build MAIN-07.42 Windows 7. I set the NLS settings, but they have no effect.

/forum/fa/13064/0/


The result of the queries below is still 15-MAR-16

create table testtable
(
  someday date
);

insert into testtable values (sysdate);

select * from testtable;



Seems like a bug. What do I have to do in order to change the NLS date setting?

Thanks,
Doug


Re: SQL Developer 3 - NLS settings not working [message #649170 is a reply to message #649166] Tue, 15 March 2016 15:33 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8790
Registered: November 2002
Location: California, USA
Senior Member
You can put the following in your SQL script:

ALTER SESSION SET NLS_DATE_FORMAT ='YYYY-MM-DD HH24:MI:SS';


Re: SQL Developer 3 - NLS settings not working [message #649172 is a reply to message #649170] Tue, 15 March 2016 15:58 Go to previous messageGo to next message
doug8294
Messages: 7
Registered: November 2011
Junior Member
Thanks. I know how to set via SQL. There would be 3 commands I would have to do, but I may open 10 or 20 connections in a day. I am trying to fix the issue with SQL developer so I don't have to copy and paste all of the commands each time.
Re: SQL Developer 3 - NLS settings not working [message #649173 is a reply to message #649172] Tue, 15 March 2016 17:14 Go to previous messageGo to next message
Littlefoot
Messages: 21331
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I have just tested it on my SQL Developer 4.1, and it works correctly.

Consider upgrading to the most recent version; why do you still use 3.x? It doesn't cost anything, after all ...
Re: SQL Developer 3 - NLS settings not working [message #649176 is a reply to message #649173] Wed, 16 March 2016 00:08 Go to previous message
doug8294
Messages: 7
Registered: November 2011
Junior Member
I tried using 4.something until all my connections disappeared, then I went back to the old one, then this NLS bug showed up. I will try the newest version and hopefully the disappearing connections bug has been fixed.

Thanks,
Doug
Previous Topic: sqlplus output formatting
Next Topic: TOAD comma question
Goto Forum:
  


Current Time: Thu Jan 18 17:02:57 CST 2018

Total time taken to generate the page: 0.02670 seconds