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

3 votes429 views1 answer
Apex call duration
SQL
1 vote380 views1 answer
Sql how to replace full stop
SQL
0 vote394 views1 answer
Sql constarint
SQL
1 vote366 views1 answer
Alter add syntax
SQL
0 vote408 views1 answer
Mysql streaming example
SQL
0 vote339 views1 answer
Mysql date only no time
SQL
0 vote355 views1 answer
Postgresql interview questions
SQL
3 votes328 views4 answers
Show sql server database
SQL
0 vote389 views1 answer
Arithmetic expression in sql
SQL
6 votes342 views4 answers
Sqlite drop table
SQL