Re: Date manipulation

Thanks, that's pretty easy.

I take it I could just use ''now'' instead of a date

dateRange = ''now''::date - ( 7 * '1 week'::interval );

Hadley

On Mon, 2004-04-19 at 10:36, Alvaro Herrera wrote:

> On Mon, Apr 19, 2004 at 09:02:35AM +1200, Hadley Willan wrote:
>
> > I want to write a function in pgsql that given a number like 7 turns
> > that into a date, 7 weeks in the past. I have a table that is
> > essentially logging some information and want to write a trigger that is
> > data driven in trimming old values out of the log, that way if I thought
> > that 4 weeks was sufficient, I could adjust the value.
>
> Just use the - operator ...
>
> alvherre=# select '2004-01-01'::date - 7 * '1 week'::interval;
> ?column?
> ---------------------
> 2003-11-13 00:00:00
> (1 fila)
>
>