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