>From: Bruno Wolff III <bruno(at)wolff(dot)to>
>To: Sal Dkj <saldkj(at)hotmail(dot)com>
>Subject: Re: Converting interval to numeric?
>Date: Thu, 10 Feb 2005 22:58:25 -0600
>On Fri, Feb 11, 2005 at 01:48:06 +0000,
> Sal Dkj <saldkj(at)hotmail(dot)com> wrote:
> > Hello, I'm trying to calculate the difference between two timestamps and
> > have the return value in minutes.
> > So, for instance:
> > Time 1 = 1/1/2005 12:00
> > Time 2 = 1/2/2005 12:00
> > If you subtract Time 1 from Time 2, it returns an interval value of '1
> > day'. Extracting hours or minutes from this obviously gives 0. What's
> > trick here?
>EXTRACT the EPOCH from the difference of the timestamps. This will give
>you the elapsed times in seconds (as a float8 I think).
Dont just search. Find. Check out the new MSN Search!
In response to
pgsql-novice by date
|Next:||From: dim||Date: 2005-02-12 08:49:48|
|Previous:||From: apocalypznow||Date: 2005-02-11 23:08:19|
|Subject: Serious connection problem|