分钟转化为小时格式 例如91分钟 ----》01:01 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 DECLARE @minute INT;SELECT @minute = 91;SELECT CONVERT(VARCHAR(8),DATEADD(minute,@minute,0),108) AS [time]; declare @mi intset @mi=91select right(100+@mi/60,2)+':'+right(100+@mi%60,2)/*---------01:31(1 行受影响)*/应该是这样吧 DECLARE @min INT DECLARE @TIME NVARCHAR(50) SET @min = 91 SET @TIME =stuff(replace(':'+convert(char(8),dateadd(minute,@min,'0:0'),108),':0',':'),1,1,'') select @TIME -------------------------------------------------- 1:31:0(所影响的行数为 1 行) --去掉后面的0的话就这样 DECLARE @min INT DECLARE @TIME NVARCHAR(50) SET @min = 91 SET @TIME =stuff(replace(':'+convert(char(8),dateadd(minute,@min,'0:0'),108),':00',''),1,1,'') select @TIME -------------------------------------------------- 01:31(所影响的行数为 1 行) DECLARE @minute INT;SELECT @minute = 91;select cast(@minute/60 as varchar)+':'+cast(@minute%60 as varchar)-------------------------------------------------------------1:31------------------------------------------------------------- SELECT CONVERT(VARCHAR(10),DATEADD(MINUTE,@Minutes,0),8) DECLARE @minute INT;SELECT @minute = 91;SELECT CONVERT(VARCHAR(5),DATEADD(minute,@minute,0),108) AS [time]; 问个有点奇怪的问题 SQL语句排错,求正解。 在存储过程中可以使用字符连接来构建SQL 语句来执行吗? 优化语句 请大虾们帮忙?? SQL安装之后注册表找不到登陆模式,是否安装错误? 关于Order的问题 如何删除订阅? 索引文件不怎明白,愿闻其详。附10个"大洋"略表心意 :-) sql server高手请进! 在线散分,求一个简单sql语句. 查询
SELECT @minute = 91;SELECT
CONVERT(VARCHAR(8),DATEADD(minute,@minute,0),108) AS [time];
set @mi=91
select right(100+@mi/60,2)+':'+right(100+@mi%60,2)
/*
---------
01:31(1 行受影响)
*/应该是这样吧
DECLARE @TIME NVARCHAR(50)
SET @min = 91
SET @TIME =stuff(replace(':'+convert(char(8),dateadd(minute,@min,'0:0'),108),':0',':'),1,1,'')
select @TIME
--------------------------------------------------
1:31:0(所影响的行数为 1 行)
DECLARE @min INT
DECLARE @TIME NVARCHAR(50)
SET @min = 91
SET @TIME =stuff(replace(':'+convert(char(8),dateadd(minute,@min,'0:0'),108),':00',''),1,1,'')
select @TIME
--------------------------------------------------
01:31(所影响的行数为 1 行)
SELECT @minute = 91;
select cast(@minute/60 as varchar)+':'+cast(@minute%60 as varchar)
-------------------------------------------------------------
1:31
-------------------------------------------------------------
SELECT CONVERT(VARCHAR(10),DATEADD(MINUTE,@Minutes,0),8)
DECLARE @minute INT;
SELECT @minute = 91;SELECT
CONVERT(VARCHAR(5),DATEADD(minute,@minute,0),108) AS [time];