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:
select ts, ts + interval dursec seconds from tmp2 limit 1;
select ts, ts + 'seconds' dursec from tmp2 limit 1;
Anyone know the correct syntax for this ?
Try
ts + dursec * '1 second'::interval
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
