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 vote304 views1 answer
MySql count occurences more than"
SQL
1 vote334 views1 answer
Postgresql pass array in function
SQL
5 votes313 views2 answers
Mysql drop table cascade
SQL
0 vote343 views1 answer
Mssql disable foreign key constraint
SQL
0 vote354 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote313 views1 answer
Composit key in sql
SQL
1 vote317 views1 answer
Sql server update column based on another table
SQL
0 vote423 views1 answer
Reset a table's identity column and remove test records
SQL
0 vote359 views1 answer
Creating sqeuence in oracle database
SQL
0 vote317 views1 answer
List mysql tables and views
SQL