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

Re: Converting interval to numeric?

From: "Sal Dkj" <saldkj(at)hotmail(dot)com>
To: bruno(at)wolff(dot)to
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Converting interval to numeric?
Date: 2005-02-12 00:38:23
Message-ID: BAY18-F6F9A130F46960362AAA16D4680@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-novice
Bruno, thanks.

>From: Bruno Wolff III <bruno(at)wolff(dot)to>
>To: Sal Dkj <saldkj(at)hotmail(dot)com>
>CC: pgsql-novice(at)postgresql(dot)org
>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 
>the
> >  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! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/


In response to

pgsql-novice by date

Next:From: dimDate: 2005-02-12 08:49:48
Subject: plpgsql
Previous:From: apocalypznowDate: 2005-02-11 23:08:19
Subject: Serious connection problem

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