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
- 12183 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
How do you create an execution plan?
What is Command line parameters in PLSQL.?
How many types of local tables are there in sql server?
What are key constraints?
Where do we use trace frag?
List all types of constraints in sql server?
What are “lost updates”?
Do you know what are the steps to process a single select statement?
What is sql server locking?
How to generate random numbers with the rand() function in ms sql server?
How to delete multiple rows with one delete statement in ms sql server?
How to transfer data from a cursor to variables with a "fetch" statement?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
Explain how to integrate the ssrs reports in application?
Which are new data types introduced in sql server 2008?
