The following CREATE FUNCTION request specifies a DateTime expression in its RETURN statement.
CREATE FUNCTION test.myudf () RETURNS DATE LANGUAGE SQL DETERMINISTIC CONTAINS SQL SPECIFIC test.myudf CALLED ON NULL INPUT SQL SECURITY DEFINER COLLATION INVOKER INLINE TYPE 1 RETURN CURRENT_DATE + 1;