public function getBirthdays(){
$queryBuilder = $em->createQueryBuilder();
$queryBuilder
->select("*")
->from("Users")
->where("DATE_FORMAT(fecha_nac,'%m-%d') = DATE_FORMAT(NOW(), '%m-%d')");
return $queryBuilder->execute()->fetchAll();
}
'2018-08-31'
All users whose fecha_nac (month and day) are the same of 'date' content
SQL |
---|
|