This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
kurs:create_calendar [2008/12/04 16:25] mh |
kurs:create_calendar [2014/09/10 21:22] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | Monatskalender beginnend mit 2008 | ||
+ | <code> | ||
+ | with | ||
+ | calendar as ( | ||
+ | select datum from | ||
+ | (select to_char(to_date( '20080101' , 'yyyymmdd')+to_yminterval(j||'-'||i), 'yyyymm') as datum from | ||
+ | (select level-1 as j from dual connect by level < 4), | ||
+ | (select level-1 as i from dual connect by level <= 12)) | ||
+ | ) | ||
+ | select * from calendar | ||
+ | </code> | ||
+ | |||
<code> | <code> | ||
select datum, sum(s) from ( | select datum, sum(s) from ( |