Re: Datums Lov
geschrieben von:
elrey (---.pools.arcor-ip.net)
Datum:
Eine kürzere Schreibweise ist:
SELECT
M AS M_RUECK ,
INITCAP(TO_CHAR(ADD_MONTHS(SYSDATE, -M),'MON/YYYY')) AS MON ,
INITCAP(TO_CHAR(ADD_MONTHS(SYSDATE, -M),'MON.YYYY')) AS MON_POINT ,
INITCAP(TO_CHAR(ADD_MONTHS(SYSDATE, -M),'YYYYMM')) AS MON_JOB ,
INITCAP(TRIM(TO_CHAR(ADD_MONTHS(SYSDATE,-M),'MONTH')))
||TO_CHAR(ADD_MONTHS(SYSDATE, -M),'/YYYY') AS MONAT ,
TO_CHAR(ADD_MONTHS(SYSDATE, -M),'MM/YY') AS MMYY ,
TO_CHAR(ADD_MONTHS(SYSDATE, -M),'MM/YYYY') AS MMYYYY,
TRUNC(LAST_DAY(ADD_MONTHS(SYSDATE, -M-1))+1) AS ERSTER_TAG ,
TRUNC(LAST_DAY(ADD_MONTHS(SYSDATE, -M))) AS LETZTER_TAG
FROM (
SELECT ROWNUM m
FROM ( SELECT 1
FROM dual
CONNECT BY LEVEL <= 36
)
)
--
Immer kurz und knapp! Es liest sich eh niemand ein Handbuch durch :-)