Home > mailing lists

sum timestamp result in hours - Mailing list pgsql-sql

From	paulo matadr
Subject	sum timestamp result in hours
Date	November 7, 2008 13:20:32
Msg-id	438124.7593.qm@web52506.mail.re2.yahoo.com Whole thread Raw
List	pgsql-sql

Select sum(age(rgat.rgat_tmencerramento, rgat.rgat_tmregistroatendimento))

from atendimentopublico.registro_atendimento rgat

inner join cadastro.localidade loca on loca.loca_id=rgat.loca_id

inner join atendimentopublico.solicitacao_tipo_especificacao step on step.step_id=rgat.step_id

where

date(rgat_tmregistroatendimento) between '2007-01-01' and '2007-12-31'

and rgat.step_id in (706,710,717,718,719,722,725,728,730,732,733,720,721,727,714,729)

and rgat.rgat_cdsituacao=2

and date(rgat_tmencerramento) between '2007-01-01' and '2007-12-31'

and rgat.rgat_tmencerramento > rgat.rgat_tmregistroatendimento

and rgat.loca_id=339

and rgat.rgat_id in

(20111305,

30102409,

30102096,

30097214,

30102396,

20057815,

20325895)

Result: 1 year 4 mons 88 days 51:42:00

I need help to view result query only in hours, the timestamp columns in bold above.

thanks

Paulo Moraes

Novos endereços, o Yahoo! que você conhece. Crie um email novo com a sua cara @ymail.com ou @rocketmail.com.

From: paulo matadr
Date: 07 November 2008, 13:15:53
Subject: Res: Finding all tables that have foreign keys referencing a table

From: paulo matadr
Date: 07 November 2008, 15:36:06
Subject: Res: sum timestamp result in hours