SELECT TO_CHAR(ADD_MONTHS(SYSDATE, -level), 'MON-YY') AS Previous_Period
FROM dual
CONNECT BY LEVEL < 5
order by (TO_CHAR(ADD_MONTHS(SYSDATE, -level), 'YYYYMM')) desc
Display Previous N period in MON-YY format
Add Comment
BI Publisher
,
BICS
,
DISPLAY N PERIODS
,
DISPLAY PREVIOUS MONTSH
,
OBIEE 12C
,
OBIEE DATE
,
PREVIOUS PERIODS
Edit
SELECT TO_CHAR(ADD_MONTHS(SYSDATE, -level), 'MON-YY') AS Previous_Period
FROM dual
CONNECT BY LEVEL < 5
order by (TO_CHAR(ADD_MONTHS(SYSDATE, -level), 'YYYYMM')) desc
0 comments:
Post a Comment