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
14316 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 advantages of partitioning?

1083

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1039

How to delete multiple rows with one delete statement in ms sql server?

981

How does a profiler work?

906

What is a schema in ms sql server 2005?

949

System variable and temporary variables

2230

Explain about integration services of Microsoft SQL server?

1016

What is isolation levels?

1009

What is the use of floor function in sql server?

1059

How to access the deleted record of an event?

1015

Explain unique key in sql server?

994

What is the purpose of grouping data in a report?

940

What the different components in replication and what is their use?

935

What is the use of sign function?

1091

Does windows server 2016 come with sql server?

918