Interested to Buy Any Domain ? << Click Here >> for more details...
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??
- 2 Answers
- 5719 Views
- I also Faced
- E-Mail Answers
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
what is hash nonclustered index
last function used in MS Access to convert sql what function will use in sql
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
When we should use and scope of @@identity?
How to create a local temporary stored procedure?
Can a cursor be updated? If yes, how you can protect which columns are updated?
How to store and query spatial data?
Explain the benefits of user-defined functions?
What is cross join in sql server joins?
What number sorts of privileges are accessible in sql?
New concepts of sql server 2005 use in your project.
What is 5nf in normalization form?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
Explain “not null constraint” in sql server?
What is the difference between ddl,dml and dcl commands?
