| 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: | Whole Thread | Raw Message | 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?? |