Fiscal Year Query Condition

[mozart]

I am trying to place a condition in my query that would limit the date range on a particular date field to data from the start of my fiscal year (1st July 2006) and now.

The 'now' part is easy because I would specify something like sysdate as my upper limit but I cannot get the 1 July 2006 without hardcoding it in my query.

I am fundamentally looking at some date arithmetic and I though of using add_months or something similar but cannot work it out.

I cannot use a parameter.

I am supprised Oracle have not built in something for the fiscal year. I am using oracle 9i so i am unsure if 10g has something.

[PAVB]

Think a litle more
Here is a hint:
-- the "year" part solution includes the words "sysdate" and "minus"
-- the "day" and "month" part of the solution includes the word "constant"