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)