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 vote257 views1 answer
Partial search in sql
SQL
6 votes266 views2 answers
Mysql interval 1 day
SQL
16 votes266 views6 answers
Install sqlite3 python
SQL
32 votes260 views6 answers
Insert into values select
SQL
1 vote255 views1 answer
Oracle split string
SQL
0 vote257 views1 answer
Enable full text search mysql
SQL
12 votes249 views5 answers
Sql primary key
SQL
2 votes249 views2 answers
Laravel query builder toSql
SQL
0 vote274 views1 answer
Proc sql not in working
SQL
0 vote268 views1 answer
Coalesce for comma separated in sql server
SQL