dokuwiki

create or replace
FUNCTION ULTIMO_VORMONAT
(datum IN date)
 RETURN DATE is 
 v_ultimo date;
BEGIN  
  select ultimo into v_ultimo from ultimo_as where
          jahr  = 
          extract(year from datum - to_yminterval('0-1')) and
          monat = 
          extract(month from datum -to_yminterval('0-1'));
  RETURN v_ultimo;
END;