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 vote208 views1 answer
Sql if clause within where clause
SQL
27 votes131 views5 answers
Add column in table
SQL
8 votes175 views3 answers
Postgres database sizes
SQL
0 vote125 views1 answer
Oracle for loop on list
SQL
0 vote125 views1 answer
Update set with inner join oracle
SQL
0 vote144 views2 answers
Faster mysql imports
SQL
11 votes153 views3 answers
Sql line numbers
SQL
0 vote139 views2 answers
Sql query for getting details by id
SQL
0 vote91 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
0 vote135 views1 answer
Db format in quotation
SQL