select concat(year(cast(date_add('${now}',- dayofweek('${now}') - 7)as string)), '年第', cast(datediff(date_add('${now}',- dayofweek('${now}') - 7),date_add(trunc(cast(date_add('${now}',- dayofweek('${now}') - 7)as string),'YY'),7 - dayofweek(trunc(cast(date_add('${now}',- dayofweek('${now}') - 7)as string),'YY'))))/7+1 as int), '周') as last1YearWeekly; ----------2020年第44周
获取上一个周六的年周 - hive sql
最新推荐文章于 2023-05-30 11:46:17 发布