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
What are types of subqueries?
What is the difference between getdate and sysdatetime?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What is a data source file?
What is query parameter in ssrs?
What are the kinds of subquery?
When do you think a developer should use sql server-based cursors?
How to create a scrollable cursor with the scroll option?
Explain triggers in sql?
What is a functions and types in sql server?
What are the properties and different types of sub-queries?
How to recover from sql injection? : sql server security
What is the use of floor function in sql server?
Is it safe to delete log files?
How to concatenate two binary strings together?