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

9 votes271 views2 answers
Default number in sql
SQL
5 votes316 views4 answers
Restart the psql server windows
SQL
-1 vote286 views3 answers
Check table exist postgresql
SQL
21 votes287 views3 answers
Average sql
SQL
3 votes295 views1 answer
Sql replace character in string in all records
SQL
1 vote299 views1 answer
Md5 encryption for existing records
SQL
0 vote283 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
0 vote297 views2 answers
How to generate a unique random number in mysql
SQL
21 votes294 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote315 views1 answer
Psql get table data types
SQL