Interval fields

From: A Gilmore <agilmore(at)shaw(dot)ca>
To: Postgresql Mailing list <pgsql-novice(at)postgresql(dot)org>
Subject: Interval fields
Date: 2005-09-30 17:01:56
Message-ID: 433D6F84.5040908@shaw.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message XXXXX XXXXXXXXXXXXXXX 2005-09-30 17:21:52 8.0.3 Installation Error On WinXP SP2
Previous Message Terry Lee Tucker 2005-09-30 10:53:25 Re: How to get tabloid