Quote Originally Posted by c0dem0nkey
Ha...thanks.

I guess I'm note sure how to do it in a sql statement. Not so much the subtraction but concurrency.
Both of these value represent the same thing. The first shows the hours, minutes and seconds of the current time as a decimal component of 1 day. i.e. since midnight .653946759 days have passed. The second shows the same thing in hours minutes and seconds.

So when you subtract one date from another you end up with a number, the whole portion of that number represents days, the decimal portion represents part of a day.


Code:
SQL> select sysdate-TRUNC(sysdate), to_char(sysdate, 'HH24:MI:SS:SSSS') from dual;
SYSDATE-TRUNC(SYSDATE) TO_CHAR(SYSDA
---------------------- -------------
            .653946759 15:41:41:4141
Does that help?