system date format is "yy-mm-dd"
"select getdate()" ----> 2009-01-24 20:03:28.513
if i write "select dateadd(dd,2,getdate())
".it returns "2009-01-26 19:59:38.340"...my question is dat
could it be possible to retrive da date in da format "26
jan 2009 ...."??
- 8 Answers
- 13067 Views
- I also Faced
- E-Mail Answers
Answer Posted / senthil kumar.m
select convert(varchar,getdate(),106)
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Does partitioning help performance?
What functions can a view be used to performed?
How do you identify a foreign key?
How can you start sql server in different modes?
What are subqueries in sql server?
Explain the functionalities that views support?
What is the process of normalising?
How can sql server instances be hidden?
How many columns can exist together per table?
What is a group function explain with an example?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
Does sql server use t sql?
What is triggers and its types?
define and explain the differences between clustered and non-clustered indexes.
Explain sub-query?
