Postgres Pro
Downloads
Home   >   mailing lists

Re: interval as hours or minutes ? - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: interval as hours or minutes ?
Date
Msg-id 20070207212519.GA14268@wolff.to
Whole thread Raw
In response to interval as hours or minutes ?  (Aarni Ruuhimäki <aarni@kymi.com>)
List pgsql-sql
Tree view 
On Wed, Feb 07, 2007 at 19:03:35 +0200, Aarni Ruuhimäki <aarni@kymi.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.

pgsql-sql by date:

Previous
From: "Demel, Jeff"
Date:
Subject: Re: metaphone and nysiis in postgres
Next
From: "Jan Muszynski"
Date:
Subject: Re: interval as hours or minutes ?