Answer / chris fauvel

--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

Answer / muhammadrashidmughal

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'

Answer / chris fauvel

--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

Answer / tp

select * from table1 where date between dateadd(yy,-
5,getdate()) and getdate()

Answer / krishna mohan thamisetty

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

What does the on update no action do?

0 Answers  

What is the diff between Static Queries and Dynamic queries give me some examples

2 Answers   CSC,

What are subquery and its properties?

0 Answers  

What the class forname () does?

0 Answers  

How to restore performance issues and how to check?

0 Answers  

How we can compare two database data?

0 Answers  

What is the Difference Between Primary and Foreign Key?

0 Answers   Accenture, Deloitte, JPMorgan Chase, Maveric,

What command would you use to add a column to a table in sql server?

0 Answers  

What is a virtual table in sql?

0 Answers  

Explain what is the function of sql server agent windows service?

0 Answers  

what are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,

How to modify existing triggers using "alter trigger"?

0 Answers