How to see time portion of date variable in debugger?

[akaya]

Hi,

When using debugger, I can only see the date portion of the variable. How can I see time portion of the variable?

Thank you.

Sample test window:

declare
v_date date:=sysdate;
begin
dbms_output.put_line(v_date);
end;

 

[Marco Kalter]

The date and time value is displayed in the nls_date_format. If you want to display date variables with time fraction, you can simply modify your test script like this:

declare
  v_date date:=sysdate;
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''');
  -- From here on dates are displayed with time fraction
  dbms_output.put_line(v_date);
end;

 

[akaya]

This works, thank you.