Re: generating date sequences

Поиск
Список
Период
Сортировка
От Patrick Scharrenberg
Тема Re: generating date sequences
Дата
Msg-id 48FC8DBB.5090304@web.de
обсуждение исходный текст
Ответ на Re: generating date sequences  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Список pgsql-sql
Hi!

>> Is there a simple way to generate sequences of dates like the following?
> Sure:
> test=# select '2008-07-03'::date + s * '1day'::interval from
> generate_Series(1,10) s;


Thanks! Thats what I was searching for.

You saved my day from manually adding missing dates in a huge excel sheet!

So thank you again!

P. Scharrenberg


В списке pgsql-sql по дате отправления: