SELECT
date_trunc( 'month', generate_series ( '2024-01-01' :: DATE, '2024-12-31' :: DATE, '1 month' :: INTERVAL ) ) AS start_date,
date_trunc( 'month', generate_series ( '2024-01-01' :: DATE, '2024-12-31' :: DATE, '1 month' :: INTERVAL ) ) + INTERVAL '1 month - 1 day' AS end_date
使用PostgreSQL的generate_series函数生成一年中每月的开始和结束日期
最新推荐文章于 2024-07-04 15:03:55 发布