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

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 / moid

8 Answers
14038 Views
I also Faced
E-Mail Answers

Answer Posted / moid

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

Is This Answer Correct ?

4 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1004

Can truncate be rolled back?

884

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1156

Define outer join in sql server joins?

890

What is the security principal at the server level that represents your session?

964

Why union all is faster than union?

865

Do you know concepts and capabilities of sql server?

1006

How to backup encryption key ?

168

How to maintain a fill factor in existing indexes?

944

Can you explain important index characteristics?

938

What is difference between rollback immediate and with no_wait during alter database?

1016

In what three ways is the return statement used in a stored procedure?

954

What is data source object?

950

Can a database be shrunk with users active?

1063

What is sql server profiler trace data file?

1050