【KingbaseES】实现MySql函数ADD_DAYS AND ADD_WEEKS

ADD_DAYS

CREATE OR REPLACE FUNCTION add_days(input_date DATE, days INTEGER) RETURNS DATE AS $$ BEGIN RETURN input_date + days; END; $$ LANGUAGE plpgsql;

ADD_WEEKS

CREATE OR REPLACE FUNCTION add_weeks(input_date DATE, weeks INTEGER) RETURNS DATE AS $$ BEGIN RETURN input_date + (weeks * INTERVAL '1 week'); END; $$ LANGUAGE plpgsql;