Horje
Monthly Birthday SQL Query Code Example
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



Sql

Related
mysql error 1064 you have an error in your sql syntax Code Example mysql error 1064 you have an error in your sql syntax Code Example
psql limit order group by Code Example psql limit order group by Code Example
postgresql inline table Code Example postgresql inline table Code Example
sql interview query questions Code Example sql interview query questions Code Example
Insert into Select * - NAYCode.com Code Example Insert into Select * - NAYCode.com Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 9



 

Horje