Re: timestamp sum question.

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: Keith Turner <kturner(at)cloudsystems(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: timestamp sum question.
Date: 2008-11-26 21:21:11
Message-ID: alpine.BSF.2.00.0811261520150.21227@thebighonker.lerctr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Wed, 26 Nov 2008, Keith Turner wrote:

[snip]
> Is it even possible to use sum for timestamps in postgres? Is there a
> way to turn the timestamp values to integers and back again?
Look at extract(epoch from ....) to get the number of seconds.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler(at)lerctr(dot)org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Keith Turner 2008-11-26 21:28:48 Re: timestamp sum question.
Previous Message Shane Ambler 2008-11-26 18:44:24 Re: PGCluster