Re: getting extract to always return number of hours

From: Rosser Schwarz <rosser(dot)schwarz(at)gmail(dot)com>
To: Chris <dmagick(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: getting extract to always return number of hours
Date: 2010-01-06 01:50:13
Message-ID: 37d451f71001051750q4d3fc5c9x355567af329fadb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, Jan 5, 2010 at 6:33 PM, Chris <dmagick(at)gmail(dot)com> wrote:
> I'm trying to get extract() to always return the number of hours between two
> time intervals, ala:

SELECT extract(epoch from timeend - timestart) / 3600 from t1;

rls

--
:wq

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Chris 2010-01-06 02:48:33 Re: getting extract to always return number of hours
Previous Message Chris 2010-01-06 01:33:59 getting extract to always return number of hours