#手动传入的所有节假日selectcast(dt as varchar(32)) as four_work_day_ago,date('-12-17') as dtfrom (selectdt,row_number() over(order by dt desc) as rank1from (values sequence(date('-12-18'),date('-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'-01-01',date'-04-06',date '-06-25',date '-06-26') and dt not between date '-01-24' and date '-01-30'and dt not between date '-05-01' and date '-05-05' and dt not between date '-10-01' and date '-10-08' )--去掉周末和节假日or dt in (date'-01-19',date '-02-01',date '-04-26',date '-05-09',date '-06-28',date '-09-27',date '-10-10') --周末上班日) where rank1=4
200字范文,内容丰富有趣,生活中的好帮手!