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

2 votes383 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
0 vote407 views1 answer
Manage Database in MySQL
SQL
15 votes352 views6 answers
Drop foreign key mysql
SQL
0 vote390 views1 answer
Selecting Multiple Columns in SQL
SQL
4 votes334 views1 answer
Update table from another table oracle
SQL
0 vote345 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote373 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
0 vote349 views1 answer
Sqlalchemy sequence postgresql
SQL
7 votes348 views3 answers
Sql get last inserted row
SQL
6 votes391 views3 answers
How to delete table sqlite
SQL