| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | Kevin Kempter <kevink(at)consistentstate(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Date math question |
| Date: | 2008-11-26 19:00:14 |
| Message-ID: | 492D9CBE.9010409@iol.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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? -
select ts, ts + (dursec * interval '1 second')....
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2008-11-26 19:19:26 | Re: Odd on-update inconsistency |
| Previous Message | hubert depesz lubaczewski | 2008-11-26 18:57:07 | Re: Date math question |