mysql今日、明日、平日、週末、今週、来週、来月のデータを取ります.
1491 ワード
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:
}
}