SUBSTR,然后将
SUM其向上,最后使用
NUMTODSINTERVALfunction将其转换为
INTERVALtype。
SELECt NUMTODSINTERVAL (SUM (total_secs), 'second') FROM (SELECt SUBSTr (duration, 1, 2) * 3600 + SUBSTr (duration, 4, 2) * 60 + SUBSTr (duration, 7, 2) total_secs FROM user_tab);
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)