hive计算指定日期所在周的第一天和最后一天

按每周第一天是周一计算

select date_add(current_date(),1 - case when dayofweek(current_date()) = 1 then 7 else dayofweek(current_date()) - 1 end) as Mo_s

按每周的最后一天是周日计算

select date_add(current_date(),7 - case when dayofweek(current_date()) = 1 then 7 else dayofweek(current_date()) - 1 end) as Sun_s

参考：/chenzechao/p/9336764.html