Using DATEADD Function compare get the requited values SELECT DATEADD(DD

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

Question Posted / gopi muluka

Answer Posted / gopi muluka

Using DATEADD Function compare get the requited values

SELECT DATEADD(DD,-6,GETDATE())

Is This Answer Correct ?

9 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is transaction server consistency?

1105

What are types of scd? : sql server analysis services, ssas

1077

What is 2nf normalization form?

1200

How do use Having,Group by,Group function in SQL?

1788

How do I view a procedure in sql server?

1036

Can sub report data source be different from that of the parent report?

149

How to throw custom exception in Stored Procedure?

1092

How do I trace a query in sql server?

998

Explain features and concepts of analysis services?

1019

What is default constraint in ms sql server?

1103

What are the differences between DDL, DML and DCL in SQL?

1278

Explain concepts of analysis services?

1012

Explain powershell included in sql server 2008?

1114

What are commit and rollback in sql?

1169

Why should you use or avoid select * statements?

1071