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