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

3 votes248 views1 answer
Oracle nextval
SQL
3 votes282 views1 answer
Increment integer in table sql
SQL
1 vote255 views1 answer
How to open closed port mysql in ubuntu
SQL
1 vote276 views1 answer
SQL Integer devision
SQL
0 vote258 views1 answer
Mysql Error Code: 1005
SQL
0 vote276 views3 answers
Select random sql
SQL
0 vote293 views3 answers
How to verify sequence result in oracle SQL
SQL
0 vote259 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
0 vote249 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote221 views1 answer
Jooq finding lastest value in table
SQL