SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

extract month

user12957777Jan 3 2011 — edited Jan 3 2011

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 31 2011

Added on Jan 3 2011

7 comments

222 views