And, of course, as soon as I post the question I find the answer,through a more intelligent search: Multiply the number by a standard interval: select N * '1 second'::interval RobR