SELECT
    IF(DATE_FORMAT(start_time,'%Y-%m-%d')<=DATE_FORMAT(NOW(),'%Y-%m-%d') and DATE_FORMAT(NOW(),'%Y-%m-%d')<=DATE_FORMAT(end_time,'%Y-%m-%d'),'01','02') a
FROM
    `t_activity`;

 

转载于:https://wwwblogs/save-shengfei/p/6728521.html

更多推荐

if函数判断日期在某个时间段