Обсуждение: 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