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

1 vote187 views1 answer
Error code 1175 mysql fix
SQL
0 vote213 views1 answer
Dump db only triggers mysql
SQL
2 votes223 views3 answers
Application.properties spring boot mysql
SQL
13 votes194 views2 answers
Check if value is null mysql
SQL
0 vote220 views1 answer
Query builder doctrien return sql
SQL
0 vote214 views1 answer
Count characters of string mysql
SQL
4 votes211 views3 answers
Is not null sql
SQL
0 vote232 views1 answer
Sql get latest of 2 datetimes
SQL
6 votes207 views3 answers
Update with inner join postgres
SQL
-1 vote216 views1 answer
Io
SQL