How to extract months for accounting year Apr - 2010 - Mar - 2011?
As the current month is Jan 2011, the statement i am using
SELECT DISTINCT EXTRACT(MONTH FROM(SYSDATE)) FROM DUAL
gives the output as 1, whereas i want the output as 13
Note: -
APR - 04
MAY - 05
JUN - 05
JUL -06
AUG -07
SEP -08
OCT -09
NOV -10
DEC -11
JAN -12
FEB -13
MAR -14
Please suggest.
Sanjay