Oracle Generate time parameter

create view date_parameter as
select
to_char(sysdate,'YYYYMMDD') as TODAY,
to_char(sysdate-1,'YYYYMMDD') as YESTERDAY,
to_char(sysdate,'YYYYMM') as THIS_MONTH,
to_char(ADD_MONTHS(sysdate,-1),'YYYYMM') as LAST_1MONTH,
to_char(ADD_MONTHS(sysdate,-2),'YYYYMM') as LAST_2MONTH,
to_char(sysdate,'YYYY') as THIS_YEAR,
to_char(sysdate - interval '1' year ,'YYYY') as LAST_1YEAR,
to_char(sysdate - interval '2' year ,'YYYY') as LAST_2YEAR,
to_char(sysdate, 'YYYYQ') as THIS_QUARTER
from dual