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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
