This shows you the differences between two versions of the page.
kurs:ultimo_vormonat [2014/09/10 21:22] |
kurs:ultimo_vormonat [2014/09/10 21:22] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <code> | ||
+ | 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; | ||
+ | </code> |