且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

选择语句以HH:MM格式显示分钟

更新时间: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