date/time functions
Hi guys,
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..
Any suggestions or do I have to write my own function?? if so, does
anyone have any pointers..
Thanks in advance..
--
Dale Walker dale@icr.com.au
Independent Computer Retailers (ICR) http://www.icr.com.au
ICRnet http://www.icr.net.au
-----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
Import Notes
Resolved by subject fallback