I knew it had to be something like this, but the search space was just
too big. Thanks!
Jim Buttafuoco wrote:
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 <[EMAIL PROTECTED]>
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 -------
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
