declare @y int; set @y = 2016; SELECT DATEDIFF(day,cast(@y as char(

How to get number of days in a given year?

Question Posted / koppalahareesh

Answer Posted / koppalahareesh

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

Please Help Members By Posting Answers For Below Questions

Difference between 2NF &3NF ?

1086

What are the five characteristics of good data?

918

Can we insert data if clustered index is disabled?

943

What is the difference between value type and reference type?

922

How to write character string constants or literals in ms sql server?

1026

What is transactional replication?

968

Can you explain what is sql server english query?

996

How do I create an extended event in sql server?

955

What is provisioning, billing and metering, and connection routing concepts in the service layer?

113

In what version of sql server were synonyms released?

942

Do you know what are pages and extents? : SQL Server Architecture

995

What are the properties of the relational tables?

881

How connect excel to sql server?

998

What is SubQuery in SQL Server 2008

1024

Does group by sort data?

902