PL/SQL first and last day of quarter of any year
Is there any way i can calculate the first and last day of the three
quarters in any year . 2012 , 2013 or 2014
SELECT ADD_MONTHS(TRUNC(SYSDATE, 'Q'), -3) AS First,
TRUNC(SYSDATE, 'Q') - 1 AS Last
FROM DUAL
calculates the first quarter of current year. i want to calculate the
first quarter of any year ?
No comments:
Post a Comment