Determining if a year is a leap year

-- Microsoft SQL Server 2000
-- Determining if a year is a leap year
SELECT CASE
            WHEN MONTH(
                        -- get the 60th day of the year
                        CAST('1/1/' + CAST(YEAR(GETDATE()) AS CHAR) AS DATETIME) + 59
                       ) = 2 
                   THEN 'TIS YEAR IS LEAP YEAR.'

            ELSE 'THIS YEAR IS NOT LEAP YEAR.'
       END
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s