Protected by Copyscape Web Copyright Protection Software

Pages

Search This Blog

Thursday, March 27, 2014

How to get year start date and end date based on period name?

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

No comments:

Post a Comment