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 vote304 views2 answers
Select last 30 days sql
SQL
0 vote279 views1 answer
Sql server roles and users
SQL
2 votes332 views3 answers
Sql delete duplicate
SQL
1 vote306 views1 answer
Primary key with prefix sql
SQL
0 vote311 views1 answer
Get role postgres
SQL
1 vote265 views2 answers
Postgresql backup and restore globals and data
SQL
10 votes294 views2 answers
Select nextval from sequence oracle
SQL
1 vote280 views1 answer
List all triggers in SQL Server
SQL
5 votes292 views1 answer
AND OR NOT operators sql
SQL
3 votes352 views1 answer
Apex call duration
SQL