- hive获取日期所在周
SELECT weekofyear('2022-08-08') as week
- hive获取日期所在周周一和周日
SELECT
date_sub(next_day('2022-08-08', 'MO'), 7) as monday
,date_add(date_sub(next_day('2022-08-08', 'MO'), 7),6) as sunday
- 日期所在年
SELECT YEAR('2022-08-08') as year
- 获取日期所在月,所在月的第一天,所在月的最后一天,上月的第一天
select
MONTH('2022-08-08') as month
,TRUNC('2022-08-08', 'MM') as first_day_of_month
,date_sub(TRUNC(add_months('2022-08-08',1), 'MM'),1) as last_day_of_month
,TRUNC(add_months('2022-08-08',-1), 'MM') as first_day_of_last_month