On Mon, Apr 19, 2004 at 11:18:23 +1200,
Hadley Willan <hadley(dot)willan(at)deeperdesign(dot)co(dot)nz> wrote:
> Thanks, that's pretty easy.
>
> I take it I could just use ''now'' instead of a date
>
> dateRange = ''now''::date - ( 7 * '1 week'::interval );
If you actually are using a date you don't have to use an interval as
the number subtracted will be in days. So you could just use
current_date - (7 * 7);