sql：生成连续时间（pgsql、hivesql）

pgsql

代码

select
	--generate_series(now()-interval '1 days','2022-01-14','1 days');
	--generate_series(to_timestamp ( '2021-11-23','YYYY-MM-DD hh24:mi:ss' ),to_timestamp ( '2022-02-21','YYYY-MM-DD hh24:mi:ss' ),'1 days' )
    generate_series(to_timestamp ('2021-11-23','YYYY-MM-DD' ),to_timestamp ('2022-02-21','YYYY-MM-DD' ),'1 days' )

结果

hive

代码

with subquery as  (
    select split(space(datediff('2020-11-04','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;

结果