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

13 votes106 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
3 votes118 views2 answers
See mysql users ubuntu
SQL
0 vote114 views1 answer
Power query datetime to date
SQL
1 vote108 views1 answer
MySQL AND Operator
SQL
0 vote111 views2 answers
Mysql get routine parameter list
SQL
1 vote72 views1 answer
Unique vs distinct sql
SQL
0 vote135 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote103 views1 answer
Psql datestyle
SQL
0 vote119 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
15 votes115 views5 answers
Show tables in oracle
SQL