Converting interval hour to minute to working days

Posted in 2004

F. Fernandez — Mon, 15 Mar 2004 15:23:30 +0000 — source: Usenet: comp.databases.informix

Hi all! I have a small problem. We're registering working hours in "interval hour to minute" and need to sum and convert them to working 8 hour days. I'd like to use only SQL, and I've been trying something like select sum(extend(spent_time*3,day to minute)) from workdone but I'm having trouble with error 561 (Sums and averages cannot be computed on datetime values). Surprisingly, if I sum() before extent(), the error is 1260 (It is not possible to convert between the specified types) select extend(sum(wn.spent_time*3),day to minute) from workdone It seems that sum() on intervals works, after all... :-( Any thoughts? We're using IDS 9.21.UC4 on Alpha. TIA -- Fernando Fernandez MoreData - Sistemas de Informa''o, Lda. http://www.moredata.pt sending to informix-list