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)