select *
from table
where date between '01/01/2003' and '12-31-2008'

or 

today is 09-08-2008

select *
from table 
where year(date)=year(getdate)-5 and month(date)= '08' and
day(date) ='09'

or 

select *
from table 
where date >='09-08-2003'
and date<='09-08-2008'

--Both use the dateadd function provided by t-sql, I'm sure 
oracle and others have similar functions

--this way is a little slower and costlier
select * 
FROM sys.tables
where modify_date between dateadd(yy, -5, getdate() ) and 
dateadd(yy, -2, getdate() )

--this way is faster and less costly, by not doing the same 
--function for every row.
declare @now datetime
, @then  datetime
select @now = convert(datetime, convert(varchar, getdate()))
     , @then  = dateadd(yy, -5, @now)

Select * 
from  sys.tables
where modify_date between @then and @now

--crap made a booboo
--corrected code here
--Both use the dateadd function provided by t-sql, I'm sure 
oracle and others have similar functions

--this way is a little slower and costlier
select * 
FROM sys.tables
where modify_date between dateadd(yy, -5, getdate() ) and 
getdate() 

--this way is faster and less costly, by not doing the same 
--function for every row.
declare @now datetime
, @then  datetime
select @now = convert(datetime, convert(varchar, getdate()))
     , @then  = dateadd(yy, -5, @now)

Select * 
from  sys.tables
where modify_date between @then and @now

select *
from table
where date between GETDATE()-(5*365) and GETDATE()