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

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

Question Posted / sreeram

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is the return type of executeupdate ()?

853

Why it is recommended to avoid referencing a floating point column in the where clause?

918

How to generate create view script on an existing view?

944

How do I view a procedure in sql server?

930

What is query optimization process?

934

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

946

Can sql servers linked to other servers?

970

What is the current limitation of the size of SQL Azure DB?

124

What is difference between clustered index and non clustered index?

1025

What number aggregate functions are accessible there in sql?

1002

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

933

What are partitioned views?

933

How can you hide the sql server instances?

970

Write the syntax for stuff function in an sql server?

976

What is the security principal at the server level that represents your session?

961