On Mon, May 16, 2005 at 11:43:09 +0300, Margus Roo <margusja@xxxxxxx> 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. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)