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
- 4852 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 transaction server implicit?
Indexes are updated automatically is the full-text index also updated automatically?
Explain the properties of subqueries in sql server?
What are binary string data types in ms sql server?
List some case manipulation functions in sql?
What are the restrictions that views have to follow?
Why we need to use secondry database file? though, we can do same work using primary database file also.
Why do you need a sql server?
whats the maximum size of view state??
How to create a local temporary stored procedure?
How to connect ms access to sql servers through odbc?
How to maintain a fill factor in existing indexes?
what is an index? : Sql server database administration
What are the purposes and advantages stored procedure?
How do use Having,Group by,Group function in SQL?
