I have a table that has a column storing dates along with other information, I want to write a query to convert the dates into fiscal year. ( June last year to July next year).
Here is a hint to get you started:
select case when extract (month from sysdate) < 7 then
extract (year from sysdate) else extract (year from sysdate) + 1 end fiscal_year