Home » SQL & PL/SQL » Client Tools » PL/SQL Developer Debug Date/Time Variable (allroundautomations PL/SQL Developer 8.0.2.1505)
PL/SQL Developer Debug Date/Time Variable [message #568869] Wed, 17 October 2012 04:19 Go to next message
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 72 times)
Re: PL/SQL Developer Debug Date/Time Variable [message #569056 is a reply to message #568869] Fri, 19 October 2012 03:20 Go to previous messageGo to next message
muralikri
Messages: 638
Registered: August 2011
Location: chennai
Senior Member

Can you post the output of below query..
select sysdate from dual 
Re: PL/SQL Developer Debug Date/Time Variable [message #586968 is a reply to message #568869] Wed, 12 June 2013 02:34 Go to previous messageGo to next message
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
Re: PL/SQL Developer Debug Date/Time Variable [message #586969 is a reply to message #586968] Wed, 12 June 2013 02:39 Go to previous messageGo to next message
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
Re: PL/SQL Developer Debug Date/Time Variable [message #587006 is a reply to message #586969] Wed, 12 June 2013 07:09 Go to previous message
Kaeluan
Messages: 178
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
Previous Topic: create .MDD file
Next Topic: TNS-03505: Failed to resolve name tips - tnsping orcl
Goto Forum:
  


Current Time: Tue Sep 30 08:39:41 CDT 2014

Total time taken to generate the page: 0.09121 seconds