Re: missing something obvious about intervals?

try


select '2005-12-01'::date + (456.5::float || ' seconds')::interval;
        ?column?
------------------------
 2005-12-01 00:07:36.50
(1 row)


---------- Original Message -----------
From: David Rysdam <drysdam@ll.mit.edu>
To: "pg >> Postgres General" <pgsql-general@postgresql.org>
Sent: Mon, 12 Dec 2005 13:00:13 -0500
Subject: [GENERAL] missing something obvious about intervals?

> I have a table that has a date field and a "real" field that represents
> a number of seconds.  I want select the date field + the seconds field.
> Just adding it doesn't work.  Casting to interval doesn't work.
> to_date/to_timestamp don't work.  How do I do this?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
------- End of Original Message -------