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 vote205 views1 answer
Opensuse start MySQL
SQL
20 votes209 views1 answer
Sql change column types
SQL
3 votes223 views2 answers
Sql asc
SQL
3 votes209 views2 answers
Funktion LOWER/UPPER sql
SQL
0 vote211 views1 answer
Xampp mysql version
SQL
-1 vote202 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote207 views3 answers
Insert or ignore postgres
SQL
2 votes229 views1 answer
Mysql id of inserted row
SQL
0 vote205 views1 answer
Time mysql w3
SQL
0 vote243 views1 answer
Databricks install odbc driver connect to sql server
SQL