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

3 votes304 views1 answer
Apex call duration
SQL
10 votes243 views4 answers
Primary key in sql
SQL
0 vote228 views1 answer
Mysql master slave setup with keepalived
SQL
0 vote251 views1 answer
Full outer join in mariadb mysql
SQL
0 vote214 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
6 votes226 views2 answers
Mysql version check cmd
SQL
3 votes267 views2 answers
Truncate table
SQL
0 vote241 views1 answer
Function plsql
SQL
0 vote231 views1 answer
Sql delete caracter list
SQL
11 votes244 views2 answers
Oracle saurce code
SQL