pears.AddRecoveryHours

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."AddRecoveryHours" IS 
{CREATE FUNCTION AddRecoveryHours 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
(IN tfrom TIME,IN tto TIME,IN hrs SMALLINT)
RETURNS TIME
BEGIN
  DECLARE rv TIME;
  IF isnull(hrs,0) <= 0 OR tfrom IS NULL OR tto IS NULL THEN
    RETURN tto
  END IF;
  IF hrs > 23 THEN
    SET hrs=23
  END IF;
  SET rv=dateadd(HOUR,hrs,tto);
  IF rv < tto AND rv >= tfrom THEN
    SET rv=dateadd(MINUTE,-1,tfrom)
  END IF;
  RETURN rv
END
}