Hi,

search for "debug date format" in this forum smile
and you'll find some topics like

http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=005327

with this hint from Marko.

Code
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;
HTH

There is no shortcut for experience(d).

PL/SQL Developer Version 10+11+12, Query Reporter Version 3.2.0.300
Oracle 11g,12c
Windows Server 2003/2008
Windows 10 Professionel 64 bit