Re: generating date sequences

From: Patrick Scharrenberg <pittipatti(at)web(dot)de>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: generating date sequences
Date: 2008-10-20 13:55:07
Message-ID: 48FC8DBB.5090304@web.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ryan Hansen 2008-10-20 19:32:34 Full Text Index Stats
Previous Message A. Kretschmer 2008-10-20 13:40:47 Re: generating date sequences