PostGrel: generate_series()
- 生成间隔中连续数值
示例: 获取指定间隔中的月份:
select
to_char(generate_series,'yyyy-mm') as monthPeriod
from
generate_series(to_char(cast('2023-01-01' as timestamp),
'yyyy-mm-dd HH24:MI:SS')::timestamp,
to_char(cast('2024-04-01' as timestamp) + interval '1 day' ,
'yyyy-mm-dd HH24:MI:SS'):: timestamp,
'1 MONTH');
示例:获取只能范围内的步长为2的数值序列
select generate_series(1,100 , 2);