From: | Dale Walker <dale(at)icr(dot)com(dot)au> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | date/time functions |
Date: | 2000-08-16 06:58:51 |
Message-ID: | 399A3BAB.38378C9D@icr.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)icr(dot)com(dot)au
Independent Computer Retailers (ICR) http://www.icr.com.au
ICRnet http://www.icr.net.au
From | Date | Subject | |
---|---|---|---|
Next Message | Ned Lilly | 2000-08-16 07:10:32 | Re: [HACKERS] Open Source Database Routs Competition in New BenchmarkTests |
Previous Message | Francisco Hernandez | 2000-08-16 06:57:54 | variables in SQL?? |