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

2 votes278 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
1 vote291 views3 answers
Rows, INSERT INTO
SQL
0 vote271 views2 answers
Sql use not in
SQL
0 vote259 views1 answer
Changer un mot de passe mysql
SQL
1 vote304 views2 answers
Intersect sql
SQL
0 vote262 views1 answer
How to query all tables mysql at the same time
SQL
0 vote283 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
0 vote342 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
0 vote269 views1 answer
Mysql procedure between two tables
SQL
1 vote283 views1 answer
Mysql event last execution
SQL