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

what are defaults? : Sql server database administration

1103

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1040

How to insert data into an existing table?

990

How can we use ConnectorJ JDBC Driver with MS SQL?

1010

How to find the list of fixed hard drive and free space on server?

1210

What are the advantages of paper records?

975

How do you use a subquery to find records that exist in one table and do not exist in another?

1056

What are the acid properties?

1016

Can you please differentiate between a primary key and a unique key?

1018

What is sql server profiler?

1023

How many types of subqueries are there in sql server?

1000

What is the importance of three tier architecture?

1099

What is checkpoint in sql server?

1177

How do use Having,Group by,Group function in SQL?

1753

How to find the second highest salary of an employee?

1190