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
- 5674 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
Write a sql query to delete duplicate records from a table called table1
Define Business Edition in SQL Azure?
What are sp_configure commands and set commands?
What is the difference between sdf and mdf?
How to delete duplicate records based on single column from a table?
What is dknf in normalization form?
How to generate random numbers with the rand() function in ms sql server?
Can a database be shrunk to 0 bytes, if not, why?
What are xml indexes?
What are the lambda triggers?
What is Command line parameters in PLSQL.?
What are extended events in sql server?
What are the benefits of filtered indexes?
How to drop an existing schema in ms sql server?
What is the cartesian product of table?
