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 is the cartesian product of table?

0 Answers  

---

Explain about integration services of Microsoft SQL server?

0 Answers  

---

Define DML and DCL statements?

1 Answers   Hexaware, NIIT,

---

What program is used to store the data source file?

0 Answers  

---

What are the type of joins? When do we use Outer and Self joins?

3 Answers  

---

---

How to create a local temporary stored procedure?

0 Answers  

---

What is the difference between dropping a database and taking a database offline?

0 Answers  

---

any one can explain Self mapping Delegation Remote Credentials

1 Answers  

---

Can we create nonclustered index in a table without creating a clustered index

1 Answers  

---

What is difference between count (*) and count column?

0 Answers  

---

What is similarity and difference between truncate and delete in sql?

0 Answers  

---

How many databases instances are there in sql server 2000?

0 Answers  

---