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 vote191 views1 answer
Oracle string substitution
SQL
0 vote206 views2 answers
Close external port 3306 with iptables
SQL
0 vote208 views1 answer
Unique element in sql
SQL
0 vote218 views1 answer
How to read the potentail error messages in ssis package
SQL
9 votes195 views2 answers
Convert data type in sql
SQL
0 vote215 views1 answer
How to move a column to different spot mysql
SQL
8 votes217 views1 answer
Oracle add datafile to tablespace
SQL
11 votes217 views2 answers
Mysql set safe mode off
SQL
6 votes212 views2 answers
Mysql check auto increment value
SQL
0 vote229 views1 answer
Postgres - Login and connect as default user
SQL