Differences

This shows you the differences between two versions of the page.

@@ 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>

dokuwiki