Thread: is in postgres solution

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?

Reg, Margusja

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.

On Mon, 2005-05-16 at 11:43 +0300, Margus Roo 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.

get the difference in minutes with:
  extract('epoch' from date2-date1) / 60
and do the formatting with / and %

or

select extract('epoch' from date2-date1)/3600
       || '::'
       || extract('minutes' from date2-date1);

gnari