Interval fields - Mailing list pgsql-novice

From A Gilmore
Subject Interval fields
Date
Msg-id 433D6F84.5040908@shaw.ca
Whole thread Raw
Responses Re: Interval fields
List pgsql-novice
Hello,

If I have an interval of say '1 day 3 hours 30 minutes' how might I
express that form of a specified interval type, ie for hours : '27.3 hours'.

Is the only option to write a function that takes an interval and
returns text in that format?

Thank you,
- A Gilmore

pgsql-novice by date:

Previous
From: Terry Lee Tucker
Date:
Subject: Re: How to get tabloid
Next
From: Michael Fuhr
Date:
Subject: Re: How to get tabloid