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

1 vote181 views1 answer
Mysql select from outside
SQL
1 vote211 views3 answers
Divide by zero error in sql
SQL
1 vote167 views1 answer
Create procedure with encryption
SQL
5 votes185 views1 answer
Sql integer to serial
SQL
0 vote154 views2 answers
Influxdb delete measurement based on date
SQL
0 vote188 views1 answer
Declaring variables in pl sql
SQL
4 votes167 views1 answer
Mysql copy table with new name
SQL
-1 vote171 views2 answers
How to display top 50 rows?
SQL
0 vote143 views1 answer
Query for maximum salary
SQL
1 vote170 views1 answer
Influxdb export to csv
SQL