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
- 5601 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
How to store and query spatial data?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
Mention the different types of replication in sql server.
How to create and drop temp table in sql server?
What are the different types of sql server replication? : sql server replication
What is spatial and temporal data?
Can you name a few encryption mechanisms in sql server?
Which language rdl files made of?
If a table does not have a unique index, can a cursor be opened on it?
How to create a view on an existing table in ms sql server?
How can I change procedure name in sql server?
What are the system database in sql server 2008?
Explain query editor regions
what is dbcc? : Sql server database administration
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
