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 vote151 views1 answer
Create a table from one field of another table
SQL
0 vote154 views1 answer
Python sqlalchemy orm to select null values
SQL
0 vote173 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
0 vote186 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL
0 vote166 views1 answer
Copy data from one postgres container to another
SQL
1 vote237 views1 answer
How to select the nth row in a SQL database table?
SQL
4 votes233 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote170 views1 answer
Postgresql import a database of gzip
SQL
0 vote156 views1 answer
SAP Return
SQL
0 vote171 views1 answer
How to access to mysql without root
SQL