SQL Server Program To Check If a Given Year is a Leap Year or Not
SQL Server Program To Check If a Given Year is a Leap Year or Not.
/*A leap year is a year that contains an extra day, February 29th, in order to keep our calendar synchronized with the Earth's revolutions around the sun. The Earth's orbit around the sun takes approximately 365.2422 days, which is slightly more than our traditional calendar year of 365 days.
To account for this discrepancy, an extra day is added to the calendar approximately every four years.
The rules for determining whether a year is a leap year are as follows:
If a year is divisible by 4, it is a leap year.
If a year is divisible by 100, it is not a leap year, unless:
If a year is divisible by 400, then it is a leap year.*/