-----Original Message-----
>I'm having trouble with converting a 'seconds' field to
>'hours:min:sec'..
>
>Using reltime, I can get a 'months day hh:mm:ss' representation, which
>is very good, but not what I need.
>
>I need to show 'hours' as the largest component..
>
>eg. it wouldn't be uncommon to deal with '2345:23:12' ie 2345 hours, 23
>min and 12 sec..
You might consider writing your own function using the pgtcl "language" of
Postgres. It's clock scan/clock format commands are just the ticket for
what you're doing.
len morgan
