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 vote202 views1 answer
Mysql type for large numbers with many decimal
SQL
3 votes190 views2 answers
Sql asc
SQL
0 vote201 views1 answer
Cast float mysql
SQL
0 vote242 views1 answer
Mysql select row with min date
SQL
16 votes191 views6 answers
Mysql find and replace
SQL
0 vote216 views3 answers
Condition in count sql
SQL
0 vote195 views1 answer
Timestamp(0) postgresql
SQL
17 votes199 views3 answers
How to change a collumn name in sql
SQL
1 vote201 views1 answer
How to fetch alternate records from two tables
SQL
0 vote188 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL