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

List the types of recovery model available in sql server?

970

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1096

What are the advantages of partitioning?

1177

What are the aggregate and scalar functions?

1129

Can we call stored procedure in view in sql server?

938

What stored by the tempdb ? : sql server database administration

1096

Define constraints and give an example of their use?

1093

How to list all columns in a table using odbc_columns()?

1031

What are rows and columns?

1063

What stored by the msdb?

1046

In what sequence sql statement is processed?

1055

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

1092

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2273

what's the difference between delete table and truncate table commands? : Sql server database administration

1038

What do you understand by recursive stored procedures?

1043