Sybernet / Supplied Procedures Reference Release 3.00 Oct 14, 2002

HTTP.SP_DATEDIFF

This procedure determines the difference between two dates and returns that difference as a formatted string, suitable for display.

Syntax

Procedure SP_DATEDIFF
(
    STARTTIME                     DATE
,   STOPTIME                      DATE
,   STRING         OUTPUT         VARCHAR2
)   ;

Parameters

starttime

stoptime

string

Example

The following example illustrates how to call sp_datediff.

declare
    starttime date := http.datetime('Oct 17, 2002');
    stoptime date := sysdate;
    string varchar(30) := null;
begin
    http.sp_datediff(starttime,stoptime,string);
    http.writeln(string);
end;



---------------------------------------------------
  3:07:34:10