Terry Lee Tucker <terry(at)esc1(dot)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