SELECT year_start_date
,last_day(add_months(trunc(year_start_date,'YYYY') , 14)) year_end_date
FROM gl_periods
WHERE period_name='MAY-13';
YEAR_START_DATE YEAR_END_DATE
-----------------------------------
01-APR-13 31-MAR-14
,last_day(add_months(trunc(year_start_date,'YYYY') , 14)) year_end_date
FROM gl_periods
WHERE period_name='MAY-13';
YEAR_START_DATE YEAR_END_DATE
-----------------------------------
01-APR-13 31-MAR-14
No comments:
Post a Comment