with subquery as  (
    select split(space(datediff('2020-11-30','2020-11-01')), ' ')  as x
) 
select 
    date_add('2020-11-01', idx) as new_date
from  
    subquery t
    lateral view 
    posexplode(x) pe as idx, ele
Logo

北京人形旗下天工造物具身智能开源社区,聚焦具身天工与慧思开物两大平台

更多推荐