sql server has its default date format in da form "yy-mm-dd"
its possible to convert da current date format of sql
server to desired format. Now my question is dat how to get
da previous and comin days date in my desired format??
Answer Posted / rohit agarwal
hello mr. ritesh u got write queary but there should be one
modification in place of strdate it will be getdate()
funtion like this:
select datedd(dd,-2,getdate())
from this queary u will get date before 2 days due to -2
ok
so swapan try this query u will get ur answer
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to create nested stored procedure?
What are “lost updates”?
What is difference in performance between insert top (n) into table and using top with insert?
Can a table be created inside a trigger?
Why normalization is used?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
What is the difference between DataRow.Delete() and DataRow.Remove()?
What is the usage of the sign function?
What is clustered vs nonclustered index?
How do you know if sql server is running on your local system?
Explain the collation?
Why do we use non clustered index?
How will you find out if there are expensive SQL statements running or not?
What are commonly used odbc functions in php?
What is recompile sql server?