How to get number of days in a given year?

Question Posted / mohamed ibrahim

4 Answers
8642 Views
ADP, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to get number of days in a given year?..

Answer / 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

How to get number of days in a given year?..

Answer / anamika devara

Getting the number of days in a year is fairly easy because you are just choosing between 365 and 366, with the latter only happening every 4 years or every leap year. To determine if it is a leap year, either of the following conditions must be met:

The year must be divisible by 4 and must NOT be divisible by 100.
The year must be divisible by 400.
Below is a user-defined function which accepts a date as a parameter and returns the number of days in that year.

CREATE FUNCTION [dbo].[ufn_GetDaysInYear] ( @pDate DATETIME )
RETURNS INT
AS
BEGIN

DECLARE @IsLeapYear BIT

SET @IsLeapYear = 0
IF (YEAR( @pDate ) % 4 = 0 AND YEAR( @pDate ) % 100 != 0) OR
YEAR( @pDate ) % 400 = 0
SET @IsLeapYear = 1

RETURN 365 + @IsLeapYear

END
GO

Is This Answer Correct ?

0 Yes

0 No

How to get number of days in a given year?..

Answer / rajkumar

DECLARE @IsLeapYear BIT

SET @IsLeapYear = 0
IF (YEAR( @pDate ) % 4 = 0 AND YEAR( @pDate ) % 100 != 0) OR
YEAR( @pDate ) % 400 = 0
SET @IsLeapYear = 1

select 365 + @IsLeapYear

Is This Answer Correct ?

0 Yes

0 No

How to get number of days in a given year?..

Answer / satya

create function abc(@lpyr int)
returns int
As

returns 365+@udflpyr (@lpyr)

....
User Defined function is declared to find a leap yr

Is This Answer Correct ?

0 Yes

5 No

Post New Answer