Re: Need beginning and ending date value for a particular week in the year

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>
Cc: Keaton Adams <kadams(at)mxlogic(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Need beginning and ending date value for a particular week in the year
Date: 2009-05-26 22:19:28
Message-ID: 20090526221928.GL32650@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alban Hertroys wrote:

> I recall using generate_series() and EXTRACT(week FROM ...) to populate
> the table in one pass for several years, but I don't have the exact
> incantation at hand now. I'd have to experiment a bit to get that back
> again, I don't have access to it anymore.

There's something similar in the Wiki:

http://wiki.postgresql.org/wiki/Date_and_Time_dimensions

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message zxo102 ouyang 2009-05-26 23:57:38 How to speed up the first-time-searching in pgsql?
Previous Message Brandon Metcalf 2009-05-26 20:09:17 Re: quoting values magic