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 vote155 views3 answers
Condition in count sql
SQL
0 vote157 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
0 vote167 views1 answer
Sql order by except one row
SQL
1 vote151 views2 answers
Pad zero sql server
SQL
0 vote175 views1 answer
Mysql join only one column
SQL
1 vote251 views1 answer
Mysql breakline on string
SQL
0 vote168 views1 answer
Full outer join in mariadb mysql
SQL
21 votes142 views6 answers
Change column in mysql
SQL
0 vote154 views1 answer
Insert set mysql
SQL
0 vote157 views1 answer
Ksql quickstart docker
SQL