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

Define compound operators?

916

What are sql dirty pages?

1027

What are the different types of collation sensitivity in sql server?

1113

How to create a user name in a database?

1054

Explain what is dbcc?

1011

Explain different types of Normalization.

1834

What is the difference between value type and reference type?

921

What is row_number()?

984

What are a database and a data warehouse?

1022

What are key constraints?

976

What is the purpose of self join?

975

What is use of except clause? How it differs from not in clause?

1019

What is 'write-ahead log' in sql server 2000 ?

1056

What is the order by used for?

1024

How many columns can exist together per table?

1156