DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world
Get Birthday From Timestamp Field
//demonstra com seleccionar todos os aniversários que ocorrerão de hoje a 15 dias
//faça cache deste dados
SELECT SQL_CACHE /*??? prefira memcache, APC, etc..*/
name,
birthday,
YEAR(birthday),
YEAR(NOW()),
(YEAR(NOW()) - YEAR(birthday)),
DATE_ADD(birthday, INTERVAL (YEAR(NOW()) - YEAR(birthday)) YEAR),
DATE_ADD(NOW(), INTERVAL 15 DAY )
FROM customers
WHERE
DATE_ADD(birthday, INTERVAL (YEAR(NOW()) - YEAR(birthday)) YEAR)
BETWEEN
DATE( NOW() )
AND
DATE_ADD(NOW(), INTERVAL 15 DAY )
