select * from generate_series(‘2018-08-01’::TIMESTAMP,‘2018-08-01’::TIMESTAMP + INTERVAL ‘1 month -1 day’, INTERVAL ‘1 day’) as days(day),xxx
postgressql crossjoin
最新推荐文章于 2024-06-12 08:36:07 发布
select * from generate_series(‘2018-08-01’::TIMESTAMP,‘2018-08-01’::TIMESTAMP + INTERVAL ‘1 month -1 day’, INTERVAL ‘1 day’) as days(day),xxx