OraFAQ Forum: Client Tools » SQL Developer 3

Home » Other » Client Tools » SQL Developer 3 - NLS settings not working (Version 3.1.07 Build MAIN-07.42 Windows 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL Developer 3 - NLS settings not working [message #649166]

Tue, 15 March 2016 11:25

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

Attachment: nls_settings.png
(Size: 27.13KB, Downloaded 3668 times)

Report message to a moderator

Re: SQL Developer 3 - NLS settings not working [message #649170 is a reply to message #649166]

Tue, 15 March 2016 15:33

Barbara Boehmer
Messages: 9106
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';

Report message to a moderator

Re: SQL Developer 3 - NLS settings not working [message #649172 is a reply to message #649170]

Tue, 15 March 2016 15:58

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.

Report message to a moderator

Re: SQL Developer 3 - NLS settings not working [message #649173 is a reply to message #649172]

Tue, 15 March 2016 17:14

Littlefoot
Messages: 21826
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 ...

Report message to a moderator

Re: SQL Developer 3 - NLS settings not working [message #649176 is a reply to message #649173]

Wed, 16 March 2016 00:08

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

Report message to a moderator

Previous Topic:	sqlplus output formatting
Next Topic:	TOAD comma question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 17 03:01:48 CST 2026