generate_series with month intervals
От
Marcus Engene
Тема
generate_series with month intervals
Дата
Msg-id
45A68AF1.6030202@engene.se
Список
Дерево обсуждения
generate_series with month intervals Marcus Engene <mengpg@engene.se>
Re: generate_series with month intervals Bruno Wolff III <bruno@wolff.to>
Re: generate_series with month intervals Tom Lane <tgl@sss.pgh.pa.us>
Re: generate_series with month intervals Marcus Engene <mengpg@engene.se>
Hi list,
I'd like to generate the latest year dynamically with generate_series.
This select works day wise:
select date_trunc ('month', now())::date + s.a
from generate_series(0, 11) as s(a)
I tried this but it didn't work:
select date_trunc ('month', now())::date + interval s.a || ' months'
from generate_series(0, 11) as s(a)
This works but looks grotesque:
select distinct date_trunc ('month', now()::date + s.a)::date
from generate_series(0, 365) as s(a)
Is there a way to do this more elegantly?
Best regards,
Marcus
В списке pgsql-general по дате отправления