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 vote132 views1 answer
Contact mysql column field
SQL
0 vote151 views1 answer
Sql server remove primary key without dropping table
SQL
1 vote91 views1 answer
Mysql show attributes of a table
SQL
0 vote125 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
0 vote152 views1 answer
Sql server pivot rows to columns
SQL
1 vote148 views2 answers
Drop table if exists test
SQL
5 votes136 views1 answer
Commentaire table oracle
SQL
0 vote125 views1 answer
Insert or update cassandra
SQL
4 votes135 views2 answers
Delete all table oracle
SQL
12 votes136 views2 answers
Delete all entries postgres
SQL