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 vote109 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote113 views1 answer
Create new table pl sql
SQL
0 vote115 views1 answer
Php mysqli install
SQL
1 vote127 views1 answer
Top 10 rows in mysql
SQL
0 vote108 views1 answer
Describe in sqlite3
SQL
4 votes233 views1 answer
Oracle show errors
SQL
0 vote112 views1 answer
Copy value from one column to another postgres
SQL
1 vote114 views1 answer
Get all db sizes in mysql server
SQL
0 vote118 views1 answer
Execute sql stored procedure in powershell
SQL
6 votes121 views1 answer
T-sql test if table exists
SQL