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 a field in a table?

1044

Explain system views?

1093

Can you explain important index characteristics?

995

What are the different types of subquery?

1163

What is transaction server explicit transaction?

1040

List out the differences between the clustered index and non-clustered index in sql server?

1010

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1093

What is the purpose of indexing?

1048

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

965

Can we use trigger new in before insert?

927

What is primary key and example?

963

What is difference between after and before?

1096

How do I create a trace in sql server?

1050

How do you start single user mode in clustered installations?

948

What are the types of lock supported by ?

1047