The following CREATE FUNCTION request specifies a bound Period function (END) and a proximity function (PRIOR) in its RETURN statement.
CREATE FUNCTION test.myudf (a PERIOD(TIME)) RETURNS TIME LANGUAGE SQL DETERMINISTIC CONTAINS SQL SPECIFIC test.myudf CALLED ON NULL INPUT SQL SECURITY DEFINER COLLATION INVOKER INLINE TYPE 1 RETURN PRIOR(END(a));