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

Explain about temporary stored procedure?

993

How to create new tables with "select ... Into" statements in ms sql server?

974

What is cursors?

1157

How to test subquery results with the exists operator?

1086

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1062

Explain the difference between delete,drop and truncate in SQL Server?

1076

What is the difference between drop table and truncate table?

912

Explain a checkpoint?

1013

How to read data in a table with "select" statements?

952

Explain the microsoft sql server delete command? : SQL Server Architecture

1052

How use inner join in sql server?

1104

Explain what is the difference between union and union all?

990

What is user-defined inline table-valued function?

927

Can coalesce return null?

993

What is the index requirement in SQL Azure?