Postgres Pro
Downloads
Home   >   mailing lists

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

From A. Kretschmer
Subject Re: interval as hours or minutes ?
Date
Msg-id 20070207174432.GA24390@a-kretschmer.de
Whole thread Raw
In response to interval as hours or minutes ?  (Aarni Ruuhimäki <aarni@kymi.com>)
List pgsql-sql
Tree view 
am  Wed, dem 07.02.2007, um 19:03:35 +0200 mailte Aarni Ruuhimäki folgendes:
> Hi all,
> 
> Could anyone please tell an easy way to get total hours or minutes from an 
> interval ?
> 
> SELECT SUM(stop_date_time - start_date_time) AS tot_time FROM work_times WHERE 
> user_id = 1;

Perhaps. You can, for instance, with extract(epoch from stop_date_time)
retrieve the number of seconds and work with this. 


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-sql by date:

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