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
- 5806 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 the difference between clustered and non-clustered indexes in ms sql server?
Difference between Logical Page and Physical Page in SSRS.
What do you know about normalization and de- normalization?
What is set nocount on and what is set nocount off?
What is built-in function?
How to stop log file growing too big?
What is explicit cursors?
Can primary key be a foreign key?
How to connect php with different port numbers?
What is difference between joins and subqueries?
How many types of functions are there in sql server?
How to delete duplicate records based on single column from a table?
Do you know what is similarity and difference between truncate and delete in sql?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
What is partition index in sql server?
