pears.weekmonthenddate

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."weekmonthenddate" IS 
{CREATE FUNCTION weekmonthenddate 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
(IN perd INTEGER,IN worm CHAR(1))
RETURNS DATE
BEGIN
  DECLARE rv DATE;
  DECLARE w INTEGER;
  DECLARE y INTEGER;
  SET y=truncnum(perd,-2);
  SET w=perd-y;
  SET y=y/100;
  IF worm = 'W' THEN
    RETURN weekenddate(y,w)
  END IF;
  SET rv=dateadd(MONTH,1+(SELECT monthoneoffset FROM params),ymd(y,w,1))-1;
  RETURN(rv)
END
}