How will you collect the date from current date to last
older 6 days date in sql server 2005
Answers were Sorted based on User's Feedback
Answer / gopi muluka
Using DATEADD Function compare get the requited values
SELECT DATEADD(DD,-6,GETDATE())
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / jitendra sharma
SELECT DATEADD(DD,-6,GETDATE()) this is right...........
Is This Answer Correct ? | 4 Yes | 0 No |
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 |
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 |
What are different types of database indexes?
write coding for importing sql data into a word excel...
What does asynchronous call backs means?
Write the Syntax for Cursors.
2 Answers CarrizalSoft Technologies, HP,
sql database suspect We have a sql database that is showing as suspect. How can we recover?
What is the difference between a primary key and a unique key? Are they the same?
How do you start single user mode in clustered installations?
Magic Tables ?
What is data mart? : sql server analysis services, ssas
How do I create a trace in sql server?
What is the purpose of data source?
what is the difference between a primary key and a unique key? : Sql server database administration