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 vote153 views4 answers
Sql rownum
SQL
2 votes145 views1 answer
Alter table add multiple columns postgresql
SQL
3 votes155 views2 answers
Having in mysql
SQL
15 votes333 views2 answers
How to sort names in alphabetical order in sql
SQL
62 votes240 views8 answers
Mysql add column
SQL
20 votes154 views1 answer
Sql change column types
SQL
8 votes144 views4 answers
Mysql update one table from another table multiple columns
SQL
13 votes143 views2 answers
Display users in mysql
SQL
2 votes136 views2 answers
Postgresql date at timezone
SQL
0 vote156 views1 answer
Make parameters nullable in sql server
SQL