如何仅从数据库中提取月份和日期以找出用户的生日，并将其与今天的日期进行比较以找出生日 - How to extract only month and day from DB to find out the birthday of a user and compare it with todays day to find out birthday

How to extract only month and day from DB to find out the birthday of a user and compare it with todays day to find out birthday

我有一个包含用户工作的用户表，现在我想从该列中提取月份和日期，以便我可以通过jgrowl发送生日通知。

我该怎么做?我正在使用MySql并使用日期作为出生日期的类型…

这样可以吗??::

public function actionBirthday(){
        $user = Query::queryOne("SELECT MONTH(date_of_birth) AS birthmonth, DAY(date_of_birth) AS birthday FROM user");
//        $date =  date('m-d');
        if($user['birthmonth'] == date('m') && $user['birthday'] == date('d')) {
            if (Yii::$app->session['user_jSN4h1wSYC7D6JFOwh6M']['role'] != Yii::$app->params['user_role']['superadmin']) {
                $log = array(
                    'content' => "Today is " . ucfirst(Yii::$app->session['user_jSN4h1wSYC7D6JFOwh6M']->username) . "Birthday",
                    'type' => "user"
                );
                Notify::sendNotification($log);
            }
        }
    }

试试这个:

select DATE(date_of_birth) as date, MONTH(date_of_birth) as month from table where column = value;
// date() will extract date and month() will extract month from date of birth column