How will you collect the date from current date to last older 6 days date in

How will you collect the date from current date to last
older 6 days date in sql server 2005

Question Posted / ramlakhan

4 Answers
5491 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How will you collect the date from current date to last older 6 days date in sql server 2005..

Answer / gopi muluka

Using DATEADD Function compare get the requited values

SELECT DATEADD(DD,-6,GETDATE())

Is This Answer Correct ?

9 Yes

0 No

How will you collect the date from current date to last older 6 days date in sql server 2005..

Answer / jitendra sharma

SELECT DATEADD(DD,-6,GETDATE()) this is right...........

Is This Answer Correct ?

4 Yes

0 No

How will you collect the date from current date to last older 6 days date in sql server 2005..

Answer / hairlin vasanth raj

ALTER procedure [dbo].[p1]
as
declare
@i int
set @i = 0
begin
set nocount on
while (@i < 6)
begin
SELECT DATEADD(DD,-@i,GETDATE()) as date
set @i=@i+1
end
end

exec p1

Is This Answer Correct ?

1 Yes

0 No

How will you collect the date from current date to last older 6 days date in sql server 2005..

Answer / sreeram

select convert(varchar,cast(dateadd(dd,-6,getdate()) as datetime),101)

ans:09/21/2010

ofcourse the above are also correct

Is This Answer Correct ?

0 Yes

0 No

Post New Answer