Date/Time Format

[Elkin]

Hi all,

When i test a procedure, i pass some date/time parameters in the format 2004/03/30. But in runtime pl sql developer shows me the variable content as 30/03/04. How can I to obtain correct format in runtime?
Thanks.

Bye.

 

[Marco Kalter]

The date (and time) value is displayed in the nls_date_format. This is an unfortunate Oracle Server behavior, the debugger doesn't even know that the variable is a date. However, 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 the session of the test script
  dbms_session.set_nls('nls_date_format','''DD-MM-YYYY HH24:MI:SS''');
  -- Run the procedure
  xyz(p1 => :p1, p2 => :p2);
end;