Monthly Birthday SQL Query

SELECT c.name
FROM cust c
WHERE (
    MONTH(c.birthdate) = MONTH(@suppliedDate)
    AND DAY(c.birthdate) = DAY(@suppliedDate)
) OR (
    MONTH(c.birthdate) = 2 AND DAY(c.birthdate) = 29
    AND MONTH(@suppliedDate) = 3 AND DAY(@suppliedDate) = 1
    AND (YEAR(@suppliedDate) % 4 = 0) AND ((YEAR(@suppliedDate) % 100 != 0) OR (YEAR(@suppliedDate) % 400 = 0))
)

Source: stackoverflow.com

Similar codes

0 vote140 views1 answer
Sql period overlap
SQL
0 vote103 views1 answer
Mysql timeout 30 seconds
SQL
0 vote161 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote106 views1 answer
Query for maximum salary
SQL
0 vote155 views1 answer
No query unable to fetch row sqlite
SQL
1 vote129 views1 answer
Error code 1055
SQL
3 votes128 views1 answer
Postgres update column with value from another table
SQL
0 vote128 views1 answer
Java input type sql date
SQL
1 vote157 views2 answers
Full join
SQL
0 vote102 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL