Terry Lee Tucker <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])