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
14430 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 the differences between triggers and stored procedures?

1070

Can two tables have the same primary key?

1208

How many types of objects are there?

1008

What is the difference between lock, block and deadlock? : sql server database administration

1046

how will add additional conditions in sql?

1104

What are the rendering extensions of ssrs?

157

What are .mdf files?

940

What is replace and stuff function in sql server?

1065

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1101

What is query cost in sql server?

995

What do you understand by replication in sql server?

1061

Explain the concepts and capabilities of sql server?

976

What's new in sql management studio for sql server? : sql server management studio

1065

How sql server executes a statement with nested subqueries?

1028

How to specify the collation for a character data type in ms sql server?

1030