Just a reminder of how to show time from a date datatype.
We all know how to strip the time off of a date by using the following command:

SELECT trunc(sysdate) from dual;

But the following takes just the time from the date variable

SELECT to_Char(sysdate,'HH:MI:SS') from dual