Postgres Pro
Downloads
Home   >   mailing lists

Re: getting extract to always return number of hours - Mailing list pgsql-sql

From Rosser Schwarz
Subject Re: getting extract to always return number of hours
Date
Msg-id 37d451f71001051750q4d3fc5c9x355567af329fadb@mail.gmail.com
Whole thread Raw
In response to getting extract to always return number of hours  (Chris <dmagick@gmail.com>)
List pgsql-sql
Tree view 
On Tue, Jan 5, 2010 at 6:33 PM, Chris <dmagick@gmail.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

pgsql-sql by date:

Previous
From: Chris
Date:
Subject: getting extract to always return number of hours
Next
From: Chris
Date:
Subject: Re: getting extract to always return number of hours