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
14432 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

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1942

What is the importance of concurrency control?

1228

What is the difference between a primary key and a unique key? Are they the same?

1077

What is the use of group by clause?

942

How to update a field in SQL after ALTERING a row?

1232

What are the advantages of partitioning?

1128

How do I edit a stored procedure in sql server?

926

What is shrink log file?

897

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1198

How to convert numeric values to integers in ms sql server?

1093

What is an etl file?

957

Why Master database is required?

1142

How to move database physical files in ms sql server?

1033

How to change the password of a login name in ms sql server?

1013

What are the benefits of normalization?

1109