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 vote152 views1 answer
Get schema of table sql
SQL
23 votes138 views6 answers
Delete all rows from table sql
SQL
0 vote138 views1 answer
Difference between varchar and varchar2
SQL
3 votes241 views1 answer
Ssh check mysql version
SQL
0 vote153 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
50 votes245 views6 answers
Sql count duplicate rows
SQL
-1 vote136 views1 answer
How to use update trigger in sql
SQL
1 vote169 views1 answer
Oracle apex version view
SQL
3 votes152 views2 answers
Create schema postgres
SQL
0 vote139 views2 answers
Mysql create table if not exists
SQL