更新时间:2022-06-13 15:43:17
这将为您提供所需的内容
This will give you what you are looking for
SELECT Convert(varchar(5), DATEADD(minute, Convert(int, YOUR-COLUMN-WITH-MINUTES), ''), 108)
示例:
Example:
SET @TestValue = '130'
SELECT Convert(varchar(5), DATEADD(minute, Convert(int, @TestValue), ''), 108)
-- Result: 02:10