Date math question

From: Kevin Kempter <kevink(at)consistentstate(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Date math question
Date: 2008-11-26 18:22:24
Message-ID: 200811261122.24456.kevin@kevinkempterllc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ?

Thanks in advance

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Kempter 2008-11-26 18:54:33 Date math question
Previous Message Steve Crawford 2008-11-26 18:05:14 Odd on-update inconsistency