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
14166 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 list all tables in the database using odbc_tables()?

1004

What is snapshot report?

159

How to use subqueries in the from clause in ms sql server?

1119

How secure is sql server database?

971

How to set the current database in ms sql server?

1033

Explain about integration services of Microsoft SQL server?

1004

How do I clean up sql server transaction log?

1022

What is the difference between NOROW and LOCKROW?

2794

How to find table changes in sql server?

1074

What are the 3 types of schema?

1065

How to use old values to define new values in update statements in ms sql server?

1201

Explain primary key, foreign key and unique key?

947

How to get the definition of a user defined function back?

1015

What is the process of indexing?

961

What are the fixed server level roles? : sql server security

1068