Leap Year in SQL

Find the Leap Year using SQL Script. We can find the leap year by passing a date value.
Declare @dt datetime = ‘2020-02-28’
Select CASE WHEN (datepart(yyyy, @dt) % 4 = 0)
THEN
CASE WHEN (datepart(yyyy, @dt) % 100 = 0)
THEN
CASE WHEN (datepart(yyyy, @dt) % 400 = 0)
THEN
‘Leap Year’
ELSE
‘No Leap Year’
END
ELSE
‘Leap Year’
END
ELSE
‘No Leap Year’
END