Check Inputed Year is leap or not using SQL function

Posted Date: 11 Dec 2008	Resource Type: Code Snippets	Category: SQL
Author: Lalit Vasant Patil	Member Level: Gold
Rating:	Points: 10

Below function is used to check wheather inputed year is leap year or not.

If inputed year is leap year then function will return "Y" otherwise return "N"



CREATE FUNCTION CheckLeapYear
(@Year Int)
RETURNS char
AS
BEGIN
    DECLARE @LeapDate datetime
    DECLARE @Day int
 
    SET @LeapDate = CONVERT(VARCHAR(4), @Year) + '0228'
    SET @Day = DATEPART(d, DATEADD(d, 1, @LeapDate))
    IF (@Day = 29)
        RETURN 'Y'
    RETURN 'N'
END

e.g : 1. If i/p is
@Year =2008 then o/p 'Y'
2. If i/p is
@Year =2009 then o/p 'N'

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Check Inputed Year is leap or not using SQL function .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Get Days In Month
	Previous Resource: Get Third Max Salary
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

Related Resources