User Tools

Site Tools


kurs:create_calendar

Differences

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

Link to this comparison view

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 (
kurs/create_calendar.txt ยท Last modified: 2014/09/10 21:22 (external edit)