Interview Questions Answers in SQL Server

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 # 14053

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 14053

Answers / { swapan }

Question { 14053 }

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