How will you collect the date from current date to last
older 6 days date in sql server 2005
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 |
Post New Answer View All Answers
What is the return type of executeupdate ()?
Why it is recommended to avoid referencing a floating point column in the where clause?
How to generate create view script on an existing view?
How do I view a procedure in sql server?
What is query optimization process?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Can sql servers linked to other servers?
What is the current limitation of the size of SQL Azure DB?
What is difference between clustered index and non clustered index?
What number aggregate functions are accessible there in sql?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
What are partitioned views?
How can you hide the sql server instances?
Write the syntax for stuff function in an sql server?
What is the security principal at the server level that represents your session?