[GENERAL] is in postgres solution

2005-05-16 Thread Margus Roo
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 ---(end of broadcast)---

Re: [GENERAL] is in postgres solution

2005-05-16 Thread Bruno Wolff III
On Mon, May 16, 2005 at 11:43:09 +0300, Margus Roo [EMAIL PROTECTED] 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?

Re: [GENERAL] is in postgres solution

2005-05-16 Thread Ragnar HafstaĆ°
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: