get financial year from a date in oracle

year_to_finyear.sql

with dates as (
        select sysdate-240 as sometime from dual
  union select sysdate-180 as sometime from dual
  union select sysdate-120 as sometime from dual
  union select sysdate-60  as sometime from dual
  union select sysdate     as sometime from dual
  union select sysdate+60  as sometime from dual
  union select sysdate+120 as sometime from dual
  union select sysdate+180 as sometime from dual
  union select sysdate+240 as sometime from dual
  union select to_date('2013-06-30', 'YYYY-MM-DD') as sometime from dual
  union select to_date('2013-07-01', 'YYYY-MM-DD') as sometime from dual
)
select
  sometime,
  'FY'||to_char(
    extract(year from sometime)
    +floor((extract(month from sometime)-1)/6)
  ) as financial_year
from dates