create procedure lib_time_add_minute (
dattim timestamp,
minutes integer)
returns (
dattim_result timestamp)
as
declare variable days double precision;
begin
if ( (dattim is null)
or (minutes is null))
then
dattim_result = null;
else
begin
/* 1 unit timestamp = 1 day = 1440 minutes = 86400 seconds */
days = cast( minutes as double precision) / cast( 1440 as double precision);
dattim_result = dattim + days;
/* or: dattim_result = dattim + ((minutes * 60) / 86400e0); */
end
suspend;
end