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 is a domain constraint give an example?
When do u use clustered index and non-clustered index?
How to connect ms access to sql servers through odbc?
Give an example of SQL injection attack ?
Introduction of rollup clause using sum and group by clause?
How to modify the underlying query of an existing view?
Explain what is the purpose of sql profiler in sql server?
What is check constraint in sql server?
What is Report Server,Report Manager and Report Builder in SSRS 2005?
What is the recovery model?
What is lock escalation and what is its purpose?
What are the default system databases in sql server 2000?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)