Re: is in postgres solution - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: is in postgres solution
Date
Msg-id 20050516194926.GA31098@wolff.to
Whole thread Raw
In response to is in postgres solution  (Margus Roo <margusja@101d.ee>)
List pgsql-general
On Mon, May 16, 2005 at 11:43:09 +0300,
  Margus Roo <margusja@101d.ee> wrote:
> Hello.
> I have 2 variables type timestamp. Example date1 = 2005-01-01 23:00 and
> date2 = 2005-05-04 12:00. I want get something like age(date2,date1) but
> ouput format must by hours::minutes.
>
> Is that bossible?

extract the epoch from the difference in timestamps and that will give
you a time in seconds that you can format as desired with a little
math.

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Distinguishing between connections in pg_hba.conf
Next
From: Adam Witney
Date:
Subject: Re: Distinguishing between connections in pg_hba.conf