1 2 3 4 5 6 7 8
| SELECT
to_date('20110101','yyyymmdd') + (rownum - 1) AS JOURID,
to_date('01'||to_char(to_date('01012011','dd/mm/yyyy') + (rownum - 1), 'mmyyyy'),'dd/mm/yyyy') AS MOISANNEE,
to_char(to_date('01012011','dd/mm/yyyy') + (rownum - 1), 'mm') AS MOIS,
to_char(to_date('01012011','dd/mm/yyyy') + (rownum - 1), 'yyyy') AS ANNEE,
last_day(to_date('20110101','yyyymmdd') + (rownum - 1)) AS DERNJOURMOIS
FROM dual
connect BY to_date('20110101','yyyymmdd') + (rownum - 1) <= to_date(to_char(add_months(sysdate,-1),'yyyy')||'1231','yyyymmdd') |
Partager