Terry Lee Tucker <terry@esc1.com> writes:
> I'm trying to figure out how to convert a floating point value into an
> interval of time.
Use something like
regression=# select (478 / 45.0) * '1 hour'::interval;?column?
----------10:37:20
(1 row)
... or whatever other scale factor you have in mind.
regards, tom lane