MySQL之查询本月的数据

    SELECT
    	* 
    FROM tb_product 
    WHERE
    	create_date BETWEEN STR_TO_DATE( date_format( CURRENT_DATE (), '%Y-%m-01 00:00:00' ), '%Y-%m-%d %H:%i:%s' ) 
    	AND STR_TO_DATE( date_format( last_day( CURRENT_DATE ()), '%Y-%m-%d 23:59:59' ), '%Y-%m-%d %H:%i:%s' )