Adding variable intervals to timestamps - Mailing list pgsql-novice

From Walker, Jed S
Subject Adding variable intervals to timestamps
Date
Msg-id F7638DABBEBB4A4CB70616DE2B19E6B80672E3@COENGEXCMB01.cable.comcast.com
Whole thread Raw
Responses Re: Adding variable intervals to timestamps
List 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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: "external" variables and triggers
Next
From: Bruno Wolff III
Date:
Subject: Re: Adding variable intervals to timestamps