Re: sum timestamp result in hours - Mailing list pgsql-sql

On Fri, Nov 7, 2008 at 9:36 AM, paulo matadr <saddoness@yahoo.com.br> wrote:
> I change form to create query  but basically need
> sum(rgat.rgat_tmencerramento - rgat.rgat_tmregistroatendimento) = result in
> hours
> sumary:
> rgat.rgat_tmencerrament = timestamp column
> gat.rgat_tmregistroatendimento = timestamp column

select extract('epoch' from '4 days 6 hours 3 minutes'::interval)*
interval '1 sec';