Try this this will works fine. select convert(varchar,dateadd(day,2,getd

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 / bipin singh

8 Answers
14318 Views
I also Faced
E-Mail Answers

Answer Posted / bipin singh

Try this this will works fine.

select convert(varchar,dateadd(day,2,getdate()),106)

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to convert character strings into numeric values?

1077

Why is replication required on the sql server?

1047

How can we migrate from SQL server to SQL Azure?

113

What are the features of Embedded SQL

1114

How to attach adventureworkslt physical files to the server?

1087

What is pessimistic concurrency?

953

Explain what are magic tables in sql server?

978

Explain rdbms?

1007

What is the difference between varchar and varchar types?

1057

Can you explain what are various ways to enhance the ssrs report?

984

What is the latest version of microsoft sql server?

1022

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1078

Mention the differences between local and global temporary tables.

1004

What is the difference between a stored procedure and a user defined function?

1009

What is simple indexing method?

999