--周一/周末
select
distinct date_time as week_start
,date_add(date_time,1 - case when DAYOFWEEK(date_time) = 1 then 7 else DAYOFWEEK(date_time) - 1 end ) as week_start
,date_add(date_time,7 - case when DAYOFWEEK(date_time) = 1 then 7 else DAYOFWEEK(date_time) - 1 end ) as week_end
from table_name
where ds = '${bdp.system.bizdate}'
hive计算指定日期的周一与周末(结束)
最新推荐文章于 2024-06-28 13:13:30 发布