本文介绍了如何在sql中计算时间格式数据?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我的桌子下面栏目记录Overtime_HHMM栏目总时间(时间格式) Overtime_HHMM 02:59:00.0000000 01:58:00.0000000 01:18:00.0000000 04:08:00.0000000 00:39:00.0000000 $ b $ 00 00:22:00.0000000 02:01:00.0000000 $ b $ 00 00:36:00.0000000 我想这个Overtime_HHMM总计是:14:01:00:0000000
My Table Below column Record Overtime_HHMM column only sum Total time in (time format) Overtime_HHMM 02:59:00.0000000 01:58:00.0000000 01:18:00.0000000 04:08:00.0000000 00:39:00.0000000 00:22:00.0000000 02:01:00.0000000 00:36:00.0000000 I want This Overtime_HHMM total is :14:01:00:0000000
推荐答案以下查询可能有所帮助。 The below query might help. SELECT SUM( DATEPART(SECOND, [Overtime_HHMM]) + 60 * DATEPART(MINUTE, [Overtime_HHMM]) + 3600 * DATEPART(HOUR, [Overtime_HHMM] ) ) as 'TotTime' FROM TableName
更多推荐
如何在sql中计算时间格式数据?
发布评论