Adding variable intervals to timestamps

From: "Walker, Jed S" <Jed_Walker(at)cable(dot)comcast(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Adding variable intervals to timestamps
Date: 2005-08-15 20:27:04
Message-ID: F7638DABBEBB4A4CB70616DE2B19E6B80672E3@COENGEXCMB01.cable.comcast.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

We need to add an interval (from a row in a table) to the curren time.
Basically,

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.

-Jed

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2005-08-15 20:44:08 Re: Adding variable intervals to timestamps
Previous Message Tom Lane 2005-08-15 19:58:05 Re: "external" variables and triggers