1、
declare @i numeric(18, 4)
set @i = 4
select @i
2、
select cast((DATEDIFF(minute, js_dcsj, js_sj) / 60) AS varchar(10)) + '小时' + cast((DATEDIFF(minute, js_dcsj, js_sj) % 60) AS varchar(10)) + '分钟' AS xfsj
declare @i numeric(18, 4)
set @i = 4
select @i
2、
select cast((DATEDIFF(minute, js_dcsj, js_sj) / 60) AS varchar(10)) + '小时' + cast((DATEDIFF(minute, js_dcsj, js_sj) % 60) AS varchar(10)) + '分钟' AS xfsj
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货