Breaking News: Grepper is joining You.com. Read the official announcement!

Monthly Birthday SQL Query

Code with bulbul answered on July 28, 2021 Popularity 7/10 Helpfulness 2/10

answer Monthly Birthday SQL Query

Monthly Birthday SQL Query

Comment

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))
)

Popularity 7/10 Helpfulness 2/10 Language sql

Source: stackoverflow.com

Tags: sql

Link to this answer
Share Copy Link