hareesh


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

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

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




Answers / { hareesh }

Question { ADP, 6071 }

How to get number of days in a given year?


Answer

declare @y int;
set @y = 2016;

SELECT DATEDIFF(day,cast(@y as char(4)), cast(@y+1 as char(4))) Days

Is This Answer Correct ?    1 Yes 0 No