关于informix时间函数中extend()输出的结果转换为小时的问题
需要计算业务人员的处理业务平均时效=处理业务时间和/总件数想要得到每笔业务处理所用的时间（精确到小时）
如：
select indate,outdate,extend(outdate,year to hour)-extend(indate,year to hour)
from prplbpmmain
where businessno= 'RDAA200923010000032701'
结果是这样的
indate outdate (expression)
2009-03-13 23:23:16 2009-03-13 23:23:17 0 00
2009-03-13 23:44:56 2009-04-21 01:25:36 38 02
2009-03-14 00:47:24 2009-03-14 00:49:22 0 00
2009-03-13 23:23:17 2009-03-13 23:44:56 0 00
2009-03-13 23:44:56 2009-03-13 23:44:56 0 00
2009-03-14 00:47:24
2009-03-13 23:23:15 2009-03-13 23:23:16 0 00
2009-03-13 23:44:57 2009-03-14 00:47:21 0 01
2009-03-14 00:47:22 2009-03-14 00:47:24 0 00
2009-03-14 00:49:23 2009-03-14 00:50:18 0 00
如果select
sum(extend(outdate,year to hour)-extend(indate,year to hour))
from prplbpmmain
where businessno = 'RDAA200923010000032701'
结果是这样的
(sum)
38 03
怎样把这个38天3小时直接转换成915小时提取出来呢？
请各位高手帮忙
页:
[1]