Re: Setting expire date on insert/modify

[Stephan Szabo <sszabo@xxxxxxxxxxxxxxxxxxxxx>]

On Tue, 24 Jan 2006, Foster, Stephen wrote:

> CREATE OR REPLACE FUNCTION "TF_BannerAd_Ads_InsMod"()
>   RETURNS "trigger" AS
> $BODY$
> DECLARE
> 	ExpireDate timestamptz;	-- Date the Banner Ad will expire.
> 	StartDate char(10);	-- Date the Banner Ad was created or
> renewed
> 	NumOfDays char(10);	-- Number of Dates the Ad will be in
> place.
> BEGIN
> 	StartDate := to_char(NEW.bannerad_creationdate, 'YYYY-MM-DD');
> 	NumOfDays := to_char(NEW.bannerad_term, '99999');
> 	ExpireDate := (date 'StartDate' + integer 'NumOfDays');

I think something like:

ExpireDate := CAST(NEW.bannerad_creationdate as Date) + NEW.bannerad_term;

may work for you.