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

20 votes127 views6 answers
Change password in mysql
SQL
0 vote126 views1 answer
Add alternate add column sql
SQL
0 vote123 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
0 vote131 views1 answer
Migration graphql
SQL
0 vote124 views1 answer
Sql date d'aujourd'hui
SQL
0 vote138 views2 answers
How to type a blank discord messgae
SQL
0 vote96 views2 answers
Avg() sql
SQL
0 vote127 views1 answer
Narural join
SQL
0 vote126 views1 answer
Power bi dax add related shows column but not working
SQL
1 vote129 views2 answers
Test sqlsrv connection
SQL