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 vote211 views1 answer
Test database for sql
SQL
2 votes179 views1 answer
Codeigniter print last sql query
SQL
0 vote191 views1 answer
How to reset table in sql server
SQL
0 vote193 views1 answer
Mariadb number format
SQL
0 vote241 views1 answer
Plsql check how much space all databases are consuming
SQL
0 vote218 views1 answer
How to run mysql on terminal mac
SQL
0 vote221 views1 answer
Login failed for user sql server
SQL
1 vote191 views1 answer
SQL query to get all table records count from a database
SQL
0 vote214 views1 answer
Sql select column name like from multiple tables
SQL
10 votes312 views4 answers
Sql server pagination
SQL