Re: interval as hours or minutes ?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Aarni Ruuhimäki <aarni(at)kymi(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: interval as hours or minutes ?
Date: 2007-02-07 21:25:19
Message-ID: 20070207212519.GA14268@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, Feb 07, 2007 at 19:03:35 +0200,
Aarni Ruuhimäki <aarni(at)kymi(dot)com> wrote:
>
> Could anyone please tell an easy way to get total hours or minutes from an
> interval ?

Extract the epoch from the interval and divide by the number of seconds
in the period of time that applies and apply appropiate rounding.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jan Muszynski 2007-02-07 22:09:41 Re: interval as hours or minutes ?
Previous Message Demel, Jeff 2007-02-07 20:31:03 Re: metaphone and nysiis in postgres