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

Answer Posted / jitendra sharma

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

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are types of subqueries?

747


What is the difference between getdate and sysdatetime?

718


Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

743


What is a data source file?

678


What is query parameter in ssrs?

132






What are the kinds of subquery?

708


When do you think a developer should use sql server-based cursors?

719


How to create a scrollable cursor with the scroll option?

671


Explain triggers in sql?

715


What is a functions and types in sql server?

748


What are the properties and different types of sub-queries?

764


How to recover from sql injection? : sql server security

699


What is the use of floor function in sql server?

725


Is it safe to delete log files?

674


How to concatenate two binary strings together?

786