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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster