MySQLデータを週ごとに集約(カスタム週の開始日)

711 ワード

$week_start = 0   // 0- 6:   -  
SELECT:

week_start=0:

CONCAT_WS('~', subdate(Fdate,date_format(Fdate,'%w')-$week_start), subdate(Fdate,date_format(Fdate,'%w')-$week_end) )

week_start=1-6:


CONCAT_WS('~', subdate(Fdate, if(date_format(Fdate, '%w')
 
   
  
 
   
  GROUP BY: 
   
  yearweek(Fdate, $week_start)