mysql取今天，明天，工作日，周末，本周，下周，下月数据

最新推荐文章于 2024-07-21 03:12:17 发布

haochunting1984

最新推荐文章于 2024-07-21 03:12:17 发布

阅读量243

点赞数

分类专栏：经验技巧 mysql 文章标签：数据库

本文链接：https://blog.csdn.net/haochunting1984/article/details/84490507

版权

经验技巧同时被 2 个专栏收录

66 篇文章 0 订阅

订阅专栏

mysql

20 篇文章 0 订阅

订阅专栏

if ($date != '') {
	switch($date){//date_add 加 date_sub 减
		case '今天':
            $where .= " AND FROM_UNIXTIME(starttimefrom,'%Y-%m-%d') = curdate() ";
            break;
		case '明天':
            $where .= " AND FROM_UNIXTIME(starttimefrom,'%Y-%m-%d') = date_add(curdate(), interval 1 day)";
            break;
		case '工作日':
            $where .= " AND dayofweek(FROM_UNIXTIME(starttimefrom)) not in (1,7) ";
            break;
        case '周末':
            $where .= " AND dayofweek(FROM_UNIXTIME(starttimefrom)) in (1,7) ";
            break;
        case '本周':
            $where .= " AND YEARWEEK(FROM_UNIXTIME(starttimefrom,'%Y-%m-%d')) = YEARWEEK(now())";
            break;
        case '下周':
            $where .= " AND ( FROM_UNIXTIME(starttimefrom,'%Y-%m-%d')>=SUBDATE(CURDATE(),DATE_FORMAT(CURDATE(),'%w')-1) AND FROM_UNIXTIME(starttimefrom,'%Y-%m-%d')<=SUBDATE(CURDATE(),DATE_FORMAT(CURDATE(),'%w')-7) ) ";
            break;
        case '下月':
            $where .= " AND FROM_UNIXTIME(starttimefrom,'%Y-%m') =  date_format(DATE_add(curdate(), INTERVAL 1 MONTH),'%Y-%m') ";
            break;
		default:
	}	
}