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).
In response to
pgsql-novice by date
|Next:||From: Michael Fuhr||Date: 2005-02-11 07:13:26|
|Subject: Re: function returning a row|
|Previous:||From: Mike G.||Date: 2005-02-11 04:39:21|
|Subject: Re: PL/pgSQL: FOT Loops vs Cursors|