Postgres Pro
Downloads
Home   >   mailing lists

Re: timestamp sum question. - Mailing list pgsql-novice

From Larry Rosenman
Subject Re: timestamp sum question.
Date
Msg-id alpine.BSF.2.00.0811261520150.21227@thebighonker.lerctr.org
Whole thread Raw
In response to timestamp sum question.  ("Keith Turner" <kturner@cloudsystems.com>)
List pgsql-novice
Tree view 
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@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893

pgsql-novice by date:

Previous
From: "Keith Turner"
Date:
Subject: Re: timestamp sum question.
Next
From: Bob McConnell
Date:
Subject: Problems updating to 8.3.5