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

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

Question Posted / jitendra sharma

Answer Posted / jitendra sharma

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are truncate options available in sql server? : sql server database administration

1034

What is dirty page?

973

Can you explain what is the use of custom fields in report?

1062

Explain about system stored procedure?

1035

What is the use of commit?

1001

How use inner join in sql server?

1134

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

881

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

952

What are various ways to enhance the ssrs report?

984

What is sparse columns of sql server 2008?

1057

What is the concept of optimization?

1060

What is format parameter in ssrs?

146

Give a example to search fr a string in all stored procedure in sql server.

987

How do you create a clustered index?

1056

What is the sql server 2000 version number?

1081