Yeah? So RTFM.

The result of TIMESTAMP - TIMESTAMP is INTERVAL DAY TO SECOND, not TIMESTAMP, as documented by Oracle here...

http://download-west.oracle.com/docs...01.htm#g196492