SELECT generate_series('2022-08-16 00:00:00' :: TIMESTAMP,
'2022-09-16 00:00:00':: TIMESTAMP,
'1 day')
generate_series(‘开始时间’::类型, ‘结束时间’::类型, ‘间隔多长时间’)
SELECT generate_series('2022-08-16 00:00:00' :: TIMESTAMP,
'2022-09-16 00:00:00':: TIMESTAMP,
'1 day')
generate_series(‘开始时间’::类型, ‘结束时间’::类型, ‘间隔多长时间’)