Wrong date format for variables in debugger

[Frank Kintrup]

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".

 

[Marco Kalter]

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:

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;