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

Explain system views?

1086

Can the query output be sorted by multiple columns in ms sql server?

980

Do you know what is a with(nolock)?

1055

Is mysql the same as sql server?

983

How to create new tables with "select ... Into" statements in ms sql server?

989

You want to implement the one-to-one relationship while designing tables. How would you do it?

965

How will you know when statistics on a table are obsolete?

1081

What are cursors and when they are useful?

1089

What is advantage data architect?

922

What is the temp table?

921

What are window functions in sql server?

1004

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

967

Explain the flow of creating a cube? : sql server analysis services, ssas

1048

Is null vs coalesce?

880

Do you know clustered and non-clustered index?

978