select convert(varchar(20),getdate()+int,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 / swapan

8 Answers
14772 Views
I also Faced
E-Mail Answers

Answer Posted / swapan

select convert(varchar(20),getdate()+int,100)

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Write a SQL query to delete a table?

1186

What is user defined stored procedures?

993

What are difference between Cluster index and Non-Cluster index?

1133

What is snapshot replication?

1102

What are horizontal and vertical scaling?

172

What are the advantages of user defined function?

1042

What the different types of Replication and why are they used?

1133

Do you know the capabilities of cursors?

1223

How do I start sql server agent automatically?

1027

How to create a stored procedure with a statement block in ms sql server?

1129

What is blocking and how would you troubleshoot it? : sql server database administration

1097

What is rtm version in sql server?

1105

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1260

What extended events?

1062

What happens to a trigger with multiple affected rows?

997