Advanced Search

Return to Snippet

Revision: 41055
at February 11, 2011 08:41 by stancox
Initial Code 
SELECT
  `student`.`FIRSTNAME`, `student`.`LASTNAME`, `student`.`BORN_DT`,
FROM
  `student`
WHERE 
NOW() > DATE(DATE_FORMAT(BORN_DT,CONCAT( EXTRACT(YEAR FROM NOW()), "-%m-%d")))
AND NOW() < DATE_ADD(DATE(DATE_FORMAT(BORN_DT,CONCAT( EXTRACT(YEAR FROM NOW()), "-%m-%d"))), INTERVAL 7 DAY)
Initial URL 









Initial Description














Initial Title





достает тех у кого ДР на каррент недели









Initial Tags














Initial Language





SQL