Use TO_CHAR function to display the Fiscal Year

Question

Is there a way in ORACLE that can display the Fiscal Year?

For example, I can write this query in SQL SERVER to pull the FYs but don't know how to write it in ORACLE.

SELECT
DATEPART(yyyy, DATEADD(mm, 3, DATE)) AS FY
FROM MYTABLE

Output:

FY
----
2009
2010
2011

What can I try to resolve this?

guess what, you could follow the advice *this* time! It's never too late :) — Jeffrey Kemp, Dec 15 '10 at 08:10

score 2 · Answer 1 · answered Dec 14 '10 at 15:18

2

The Oracle equivalent of your query would be something like this:

SELECT EXTRACT(YEAR FROM ADD_MONTHS(MYDATE, 3)) AS FY
FROM MYTABLE

answered Dec 14 '10 at 15:18

Álvaro González

1

If you want to be totally standards compliant, use *EXTRACT(YEAR FROM mydate + INTERVAL '3' MONTH)* – Dec 14 '10 at 18:54

score 0 · Answer 2 · answered Dec 14 '10 at 15:23

0

SELECT TO_CHAR(ADD_MONTHS(MYDATE, 3),'YYYY') fy FROM MYTABLE

Is probably the same

answered Dec 14 '10 at 15:23

stjohnroe

2 Answers2