It is amazing how sometimes you can get so pigeon-holed by the docs that
you don't see the obvious.
Thank you very much!
From: Bruno Wolff III [mailto:bruno(at)wolff(dot)to]
Sent: Monday, August 15, 2005 2:44 PM
To: Walker, Jed S
Subject: Re: Adding variable intervals to timestamps
On Mon, Aug 15, 2005 at 14:27:04 -0600,
"Walker, Jed S" <Jed_Walker(at)cable(dot)comcast(dot)com> wrote:
> We need to add an interval (from a row in a table) to the curren time.
> Table1 has the column offset_in_secs that is an integer.
> Select current_timestamp + '<offset_in_secs> seconds' from table1;
> But can't figure out how to do this.
Select current_timestamp + offset_in_secs * '1 seconds' from table1;
pgsql-novice by date
|Next:||From: Aarni Ruuhimäki||Date: 2005-08-16 08:32:44|
|Subject: Re: Cron jobs and backup|
|Previous:||From: Bruno Wolff III||Date: 2005-08-15 20:44:08|
|Subject: Re: Adding variable intervals to timestamps|