Advanced Search

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

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT
  2.   `student`.`FIRSTNAME`, `student`.`LASTNAME`, `student`.`BORN_DT`,
  3. FROM
  4.   `student`
  5. WHERE 
  6. NOW() > DATE(DATE_FORMAT(BORN_DT,CONCAT( EXTRACT(YEAR FROM NOW()), "-%m-%d")))
  7. AND NOW() < DATE_ADD(DATE(DATE_FORMAT(BORN_DT,CONCAT( EXTRACT(YEAR FROM NOW()), "-%m-%d"))), INTERVAL 7 DAY)

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.