Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Keith TurnerDate: 2008-11-26 21:28:48
Subject: Re: timestamp sum question.
Previous:From: Shane AmblerDate: 2008-11-26 18:44:24
Subject: Re: PGCluster

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group