How to calculate difference in time?

From: Robert Chung <robertch_at_mindspring.com>
Date: Mon, 31 Aug 1998 22:05:52 GMT
Message-ID: <35eb009c.28919313@news.mindspring.com>

Does anyone know how to calculate difference in time? Following is something that I tried.

declare
  date_X date;
  date_Y date;
begin
  date_X:=SYSDATE;

  date_Y:=SYSDATE;
  dbms_output.put_line(
    to_char(date_Y-date_X,
      'MM:DD:YYYY HH24:MI:SS'));

end;
/

Following is the output that I got.

Statement processed.
##########

All I want is the difference in time (possibly to the micro second). Is there any way to do it? Thank you. Received on Mon Aug 31 1998 - 17:05:52 CDT