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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
On Wed, 26 Nov 2008, Keith Turner wrote:

> 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           
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


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-2017 The PostgreSQL Global Development Group