Postgres Pro
Downloads
Home   >   mailing lists

Retrieving INTERVAL as float hours? - Mailing list pgsql-general

From Ken Causey
Subject Retrieving INTERVAL as float hours?
Date
Msg-id 3.0.1.32.20000712091410.017c4b08@premiernet.net
Whole thread Raw
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Lamar Owen
Date:
Subject: Re: [HACKERS] pg_dump & blobs - editable dump?
Next
From: Philip Warner
Date:
Subject: Re: RE: [HACKERS] pg_dump & blobs - editable dump?