Retrieving INTERVAL as float hours?

From: Ken Causey <ken(at)premiernet(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Retrieving INTERVAL as float hours?
Date: 2000-07-12 14:14:10
Message-ID: 3.0.1.32.20000712091410.017c4b08@premiernet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This may be a stupid question, and feel free to RTFM me, but please
specify the manual/book as I can't seem to find this. I want
to retrieve an INTERVAL (the sum of INTERVALS actually) as a float
hour. In other words if I normally get an output like

@ 2 hours 30 minutes

I would like

2.5

Thanks in advance for all help.

Ken Causey

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Philip Warner 2000-07-12 14:17:28 Re: RE: [HACKERS] pg_dump & blobs - editable dump?
Previous Message Lamar Owen 2000-07-12 14:13:39 Re: [HACKERS] pg_dump & blobs - editable dump?