pears.weekmonthenddate

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

Original SQL

CREATE FUNCTION "pears"."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