kurs:create_calendar
Differences
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 ( | ||
kurs/create_calendar.1228404327.txt.gz ยท Last modified: 2014/09/10 21:22 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
