On Fri, Nov 7, 2008 at 9:36 AM, paulo matadr <[EMAIL PROTECTED]> 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';
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
