Wrong date format for variables in debugger - Allround Automations forums

Register Log In

Forums Products PL/SQL Developer Wrong date format for variables in debugger

Print Thread

Wrong date format for variables in debugger #43529 03/09/12 09:44 AM
Joined: Apr 2006 Posts: 77 F Frank Kintrup OP Member
OP Frank Kintrup Member F Joined: Apr 2006 Posts: 77	When I view a date variable in the debugger the date format is wrong, it does not use the NLS format set in the preferences. In preferences I've set the date format to "dd.mm.yyyy", but date variables are always displayed like "31-DEC-99".

Re: Wrong date format for variables in debugger Frank Kintrup #43533 03/09/12 11:17 AM
Joined: Aug 1999 Posts: 22,218 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,218	The date (and time) value is displayed in the nls_date_format. If you want to test procedure xyz and display date variables with a specific format, you can simply modify your test script like this: Code begin -- Modify the nls_date_format for this session dbms_session.set_nls(param => 'nls_date_format', value => '''DD-MM-YYYY HH24:MI:SS'''); -- Run the procedure xyz(p1 => :p1, p2 => :p2); end; Marco Kalter Allround Automations

Moderated by support

Link Copied to Clipboard

Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)

Responsive Width:

PHP: 7.1.33 Page Time: 0.030s Queries: 14 (0.008s) Memory: 2.4983 MB (Peak: 3.0405 MB) Data Comp: Off Server Time: 2024-05-15 01:51:00 UTC
Valid HTML 5 and Valid CSS