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 vote263 views3 answers
Call to undefined function mysql_connect()
SQL
2 votes260 views1 answer
Create mysql user on all hosts
SQL
0 vote250 views1 answer
Alter table engine mysql
SQL
0 vote258 views1 answer
Compare field sql server
SQL
5 votes229 views2 answers
Oracle tables with column name
SQL
4 votes228 views1 answer
Oracle user tables
SQL
9 votes240 views4 answers
Oracle get table column names
SQL
0 vote243 views2 answers
Search stored procedures
SQL
2 votes186 views1 answer
Oracle current date without time
SQL
0 vote256 views1 answer
List in one column mysql
SQL