swapan


{ City }
< Country > india
* Profession * fresher
User No # 25774
Total Questions Posted # 1
Total Answers Posted # 1

Total Answers Posted for My Questions # 8
Total Views for My Questions # 12190

Users Marked my Answers as Correct # 0
Users Marked my Answers as Wrong # 1
Questions / { swapan }
Questions Answers Category Views Company eMail

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 ...."??

8 SQL Server 12190



Answers / { swapan }

Question { 12190 }

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 ...."??


Answer

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

Is This Answer Correct ?    0 Yes 1 No