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

How to know whether our backup is succesfully taken?

1 Answers  

---

What is a view? is View updatable?

17 Answers   IBM, L&T,

---

Explain primary key, foreign key and unique key?

1 Answers  

---

What are statistics, under what circumstances they go out of date, how do you update them?

2 Answers   HCL,

---

What do you mean by the term 'normalization'?

1 Answers   Tech Mahindra,

---

What is the difference between createstatement and preparedstatement?

1 Answers  

---

How to assign new column names in a view?

1 Answers  

---

What are different type of Collation Sensitivity?

1 Answers  

---

Differentiate between sql temp table vs table variable?

1 Answers  

---

What is the osql utility?

1 Answers  

---

What is oltp (online transaction processing)?

1 Answers  

---

A trigger can reference objects outside the current database? State true or false.

1 Answers  

---