尝试
SELECT LTRIM(DATEDIFF(MINUTE, 0, TimeSpent))
FROM yourtable
给定
| TIMESPENT |
-------------
| 00:12 |
| 01:05 |
| 10:00 |
输出:
| MINUTES |
-----------
| 12 |
| 65 |
| 600 |
这是
在SQL Server 2008中将Varchar HH:MM转换为整数分钟的查询
尝试
SELECT LTRIM(DATEDIFF(MINUTE, 0, TimeSpent))
FROM yourtable
给定
| TIMESPENT |
-------------
| 00:12 |
| 01:05 |
| 10:00 |
输出:
| MINUTES |
-----------
| 12 |
| 65 |
| 600 |
这是