尝试
SELECt LTRIm(DATEDIFF(MINUTE, 0, TimeSpent)) FROM yourtable
| TIMESPENT |-------------| 00:12 || 01:05 || 10:00 |
输出:
| MINUTES |-----------| 12 || 65 || 600 |
这是 SQLFiddle
欢迎分享,转载请注明来源:内存溢出
尝试
SELECt LTRIm(DATEDIFF(MINUTE, 0, TimeSpent)) FROM yourtable
| TIMESPENT |-------------| 00:12 || 01:05 || 10:00 |
输出:
| MINUTES |-----------| 12 || 65 || 600 |
这是 SQLFiddle
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)