DECLARE @year AS INT SET @year=2010 Select DATEDIFF(DAY,DATEADD(YEAR,@yea

How to get number of days in a given year?

Question Posted / akshay wadkar

Answer Posted / akshay wadkar

DECLARE @year AS INT
SET @year=2010
Select DATEDIFF(DAY,DATEADD(YEAR,@year-1900,0)
,DATEADD(YEAR,@year-1900+1,0)) AS [TOTAL NO OF DAYS]
GO

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Distinguish between nested subquery and correlated subquery?

975

What is the recovery model?

932

What are logical/boolean operations in ms sql server?

982

What is the latest version of microsoft sql server?

970

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

957

Does partitioning ssd reduce performance?

849

Can we insert data if clustered index is disabled?

893

What are the difference between clustered and a non-clustered index?

980

what is raid? : Sql server database administration

974

What is the difference between count () and rowcount ()?

948

What are key constraints?

929

What is format parameter in ssrs?

136

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

966

What do you mean by data integrity?

998

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

304