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 -------