我的表格中有一duration列类型的列。time(7)appointments
我知道如何使用
select durationMinutes = DateDiff(n, a.StartOn, a.EndOn)
from appointments a
但我的duration专栏是time(7)。
如何将转换int为duration？
declare @Time as Time(7) = '01:02:03';
select @Time as 'Time(7)', DateDiff( minute, 0, @Time ) as 'Minutes';
declare @Minutes as Int = 90;
select @Minutes as 'Minutes', Cast( DateAdd( minute, @Minutes, 0 ) as Time(7) ) as 'Time(7)';
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句