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

4 votes336 views2 answers
Oracle unlock user
SQL
0 vote367 views1 answer
Postgresql print sessions using the database
SQL
0 vote332 views1 answer
Sql dmv to capture updates
SQL
25 votes328 views3 answers
Mysql command show tables
SQL
3 votes315 views4 answers
Show columns from table
SQL
0 vote376 views1 answer
Move table to a different schema
SQL
2 votes331 views2 answers
Oracle no data found error code
SQL
1 vote343 views1 answer
Drop column if exists sql server
SQL
2 votes327 views1 answer
Sql update alias
SQL
3 votes325 views1 answer
Oracle user privileges
SQL