OraFAQ Forum: Client Tools » PL/SQL Developer Debug Date/Time Variable

Home » Other » Client Tools » PL/SQL Developer Debug Date/Time Variable (allroundautomations PL/SQL Developer 8.0.2.1505)

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

PL/SQL Developer Debug Date/Time Variable [message #568869]

Wed, 17 October 2012 04:19

gatemaster99
Messages: 1
Registered: October 2012

Junior Member

Hi,

I have a little problem when debugging in pl/sql developer.
All date variables are always displayed DD-MON-RR.
I already changed the values for Date and Time to YYYY-MM-DD HH24:MI:SS in
Tools => Preferences => User Interface / NLS Options.
But when I start debugging and watch a variable I still get eg. 17-OCT-12 without the time.
I already restarted pl/sql developer. No change.

Thanks for your help!

Attachment: Snap10.jpg
(Size: 70.88KB, Downloaded 1969 times)

Report message to a moderator

Re: PL/SQL Developer Debug Date/Time Variable [message #569056 is a reply to message #568869]

Fri, 19 October 2012 03:20

muralikri
Messages: 638
Registered: August 2011
Location: chennai

Senior Member

Can you post the output of below query..

select sysdate from dual

Report message to a moderator

Re: PL/SQL Developer Debug Date/Time Variable [message #586968 is a reply to message #568869]

Wed, 12 June 2013 02:34

fatkut
Messages: 2
Registered: June 2013
Location: Istanbul

Junior Member

Hi;
Did you find a solution for this.

Im having the same problem.

Regards
Fatih

Report message to a moderator

Re: PL/SQL Developer Debug Date/Time Variable [message #586969 is a reply to message #586968]

Wed, 12 June 2013 02:39

fatkut
Messages: 2
Registered: June 2013
Location: Istanbul

Junior Member

hi;
This can be a solution.
Add this line at the beginning of your code..
Quote:

dbms_session.set_nls('nls_date_format','''DD-MM-YYYY HH24:MI:SS''');

found @ http://forums.allroundautomations.com/ubb/ubbthreads.php?ubb=showflat&Number=30805&PHPSESSID=2e3c1b028a66500ae8a1730abc88b993

Report message to a moderator

Re: PL/SQL Developer Debug Date/Time Variable [message #587006 is a reply to message #586969]

Wed, 12 June 2013 07:09

Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec

Senior Member

Hi,
You can also set your nls_date_format in the windows registry for the oracle_home that is used by PLSQL Developer

Report message to a moderator

Previous Topic:	create .MDD file
Next Topic:	TNS-03505: Failed to resolve name tips - tnsping orcl

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 06:45:29 CDT 2025