Leap Year 1

[VBXL]

Hi

Does anybody know how to find out if a year is a Leap Year

Cheers

xplain

 

[tlbroadbent]

Let SQL Server tell you by using the IsDate function.

If IsDate('02/29/2000')=1
Print 'Is Leap Year'
Else
Print 'Is Not Leap Year'

Check the current year:

If isdate('02/29/'+cast(year(getdate()) As char(4)))=1
Print 'Is Leap Year'
Else
Print 'Is Not Leap Year'

Alternate syntax:
If IsDate('02/29/'+ltrim(str(year(getdate()))))=1
Print 'Is Leap Year'
Else
Print 'Is Not Leap Year' Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[fluteplr]

Or generically. A year is a leap year as long as:

It is divisible by 4 and
(It is not divisible by 100 or it is divisible by 400)


In other words 1900 was not a leap year, 2000 was, 2100 will not be.