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!
S
am Mon, dem 20.10.2008, um 15:24:38 +0200 mailte Patrick Scharrenberg
folgendes:
> Hi!
> Is there a simple way to generate sequences of dates like the following?
> "2008-07-03 00:00:00"
> "2008-07-04 00:00:00"
> "2008-07-05 00:00:00"
> "2008-07-06 00:00:00"
>
Sure:
test
