Re: sum timestamp result in hours

On Fri, Nov 7, 2008 at 9:36 AM, paulo matadr <saddoness(at)yahoo(dot)com(dot)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';