select convert(varchar(20),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 / shailesh s. deshmukh

8 Answers
14763 Views
I also Faced
E-Mail Answers

Answer Posted / shailesh s. deshmukh

select convert(varchar(20),getdate(),106)

Is This Answer Correct ?

4 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

which backup strategy you are following at ur company

2193

What is sleeping status in sql server?

1075

What are sub reports?

208

What is sql or structured query language?

1199

Name some of the open source software that you can use in alternative to SSR?

170

Explain transaction server explicit transaction?

971

What is the name of the system variable that returns the number of rows affected by a SQL statement?

1066

What are dml triggers and types of dml triggers?

1028

Explain SSRS Architecture?

201

What command is used to create a database in the sql server and how?

1241

How many types of triggers in sql server?

1089

can any body tell me how to know the password of current user in sql server

2119

what is the difference between openrowset and openquery?

1155

What are the differences between left join and inner join in sql server?

1153

How do I trace a query in sql server?

1000