select convert(varchar,getdate(),106)

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 ...."??

Question Posted / senthil kumar.m

8 Answers
14040 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

Please Help Members By Posting Answers For Below Questions

what are the critical issues you have resloved in your company

1920

What is serializable?

996

What is store procedure? When do you use?

871

Define right outer join?

931

What are different types of collation sensitivity?

941

What do you understand by SQL*Net?

957

What is store procedure? How do they work? When do you use?

886

What are the requirements for sql server 2016?

851

What is a performance monitor?

921

Is there any difference between the primary key and unique key?

949

How do I create an extended event in sql server?

904

Using the customer, and order table in northwind database, please write a query to produce xml?

1007

What are the mathematical functions supported by sql server 2005?

996

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

1961

How to test odbc dsn connection settings?

967