date/time functions - Mailing list pgsql-general

From Dale Walker
Subject date/time functions
Date
Msg-id 399A3BAB.38378C9D@icr.com.au
Whole thread Raw
List pgsql-general
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

pgsql-general by date:

Previous
From: John Morton
Date:
Subject: Unimpletmented features
Next
From: Ned Lilly
Date:
Subject: Re: [HACKERS] Open Source Database Routs Competition in New BenchmarkTests