Kevin Kempter wrote:
Hi All;
I have a table that contains 2 columns ts (a timestamp) and dursec (a float -
number of seconds)
I want to insert the following into another table:
the ts (timestamp column) and a second date which is ts + dursec
I tried these select variations with no luck:
se
Hi All;
I have a table that contains 2 columns ts (a timestamp) and dursec (a float -
number of seconds)
I want to insert the following into another table:
the ts (timestamp column) and a second date which is ts + dursec
I tried these select variations with no luck:
select ts, ts + interval d
On 26/11/2008 18:54, Kevin Kempter wrote:
> I have a table that contains 2 columns ts (a timestamp) and dursec (a float -
> number of seconds)
>
> I want to insert the following into another table:
>
> the ts (timestamp column) and a second date which is ts + dursec
Something like this? -
sel
On Wed, Nov 26, 2008 at 11:54:33AM -0700, Kevin Kempter wrote:
> select ts, ts + interval dursec seconds from tmp2 limit 1;
> select ts, ts + 'seconds' dursec from tmp2 limit 1;
select ts, ts + dursec * '1 second'::interval ...
depesz
--
Linkedin: http://www.linkedin.com/in/depesz / blog: htt
Hi All;
I have a table that contains 2 columns ts (a timestamp) and dursec (a float -
number of seconds)
I want to insert the following into another table:
the ts (timestamp column) and a second date which is ts + dursec
I tried these select variations with no luck:
select ts, ts + interval d
