On Tue, 11 Jan 2005, Terry Lee Tucker wrote:
> Hello:
>
> I'm trying to figure out how to convert a floating point value into an
> interval of time. I'm calculating the time required to drive from point A to
> point B. For the sake of this question, we'll just say it is miles/speed. So:
>
> drv_time = 478 / 45.0;
>
> The value of this is: 10.6222222222222222
I think something like
478/45.0 * interval '1 hour'
may do what you want.