Wednesday 27 April 2022

Oracle Apps + 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


Regards,
Amar

1 comments:

Asley Patricia said...

Creative and pleasant services available here, but the most part of this all criteria is so delightful and authorized as well. But also get the most effective dissertation writing services are always available in London city easily.

Post a Comment