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 vote264 views2 answers
Postgresql could not start server mac
SQL
1 vote325 views1 answer
Oracle nvl2
SQL
0 vote298 views1 answer
Original Query
SQL
1 vote295 views1 answer
Oracle db create new schema
SQL
11 votes746 views4 answers
Reset identity column values in sql server
SQL
-3 votes332 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
7 votes305 views6 answers
Group_concat mysql
SQL
0 vote275 views1 answer
Sql requete number pair
SQL
0 vote322 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
1 vote295 views2 answers
String to date postgres
SQL