presto-获取当前日期的最近n个工作日

#手动传入2020年的所有节假日
selectcast(dt as varchar(32)) as four_work_day_ago,date('2019-12-17') as dt
from 
(selectdt,row_number() over(order by dt desc) as rank1from (values sequence(date('2019-12-18'),date('2019-12-18')-interval '20' day)) as D(t)--传参获取时间段 cross join unnest(t) as D(dt)where (dow(dt) between 1 and 5 and dt not in (date'2020-01-01',date'2020-04-06',date '2020-06-25',date '2020-06-26') and dt not between date '2020-01-24' and date '2020-01-30'and dt not between date '2020-05-01' and date '2020-05-05' and dt not between date '2020-10-01' and date '2020-10-08' )--去掉周末和节假日or dt in (date'2020-01-19',date '2020-02-01',date '2020-04-26',date '2020-05-09',date '2020-06-28',date '2020-09-27',date '2020-10-10') --周末上班日
) where rank1=4

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！