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 vote146 views1 answer
Mysql select top 2
SQL
0 vote181 views1 answer
Oracle query to see what scema i am working in
SQL
4 votes171 views1 answer
Id primary key auto generated
SQL
4 votes170 views3 answers
Order by value mysql
SQL
2 votes304 views1 answer
Postgresql group by month and year
SQL
0 vote186 views1 answer
Recover deleted data from mysql database
SQL
2 votes216 views1 answer
Mariadb select multiple rows into one column
SQL
0 vote169 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
1 vote174 views1 answer
How to delete record sql delphi
SQL
2 votes183 views2 answers
Mamp connect mysql terminal
SQL