DECODE

I have to run a query to give a column a value based on a time range. Can I use DECODE?

select decode(trans_date, trans_date>='01-Jul-2002' and trans_date<='30-Jun-2003','Fiscal2002', .....) as fiscal, from. . .
where. . . Received on Thu Apr 01 2004 - 16:20:31 CST