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
14029 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 is difference between standardization and normalization?

1015

What is the exact numeric data type in sql?

957

What are the 10 characteristics of data quality?

895

Explain difference between control flow and data flow?

901

Can we call future method from queueable?

988

What is compression - row-level and page-level compression?

862

Define msdb database?

969

what changed between the previous version of sql server and the current version? : Sql server database administration

953

What is the default sql server instance name?

968

What do I need to start working with sql studio? : sql server management studio

1047

How do I clean up sql server transaction log?

990

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

970

Explain nested join?

920

What are the properties of primary key?

909

can we have a nested transaction? : Sql server database administration

989