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

1 vote177 views1 answer
Sql how to duplicate a table
SQL
0 vote167 views1 answer
Changer un mot de passe mysql
SQL
0 vote177 views2 answers
Suse stop MySQL
SQL
0 vote161 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
0 vote160 views1 answer
Stop psql server windows
SQL
0 vote185 views2 answers
Sql day from datetime
SQL
0 vote120 views1 answer
Get last run query sql server
SQL
0 vote169 views2 answers
How to generate a unique random number in mysql
SQL
1 vote243 views2 answers
Copy table in sql
SQL
1 vote164 views1 answer
Oracle create_program
SQL