34,575
社区成员
发帖
与我相关
我的任务
分享
create table tab(time int)
insert into tab values(96108)
insert into tab values(108)
go
--如果是秒
select time [如果time是秒], cast(time / (60*60) as varchar) + '时' +
cast((time % (60*60))/60 as varchar) + '分' +
cast(time % 60 as varchar) + '秒'
from tab
/*
如果time是秒
----------- ------------------------------------------------------------------------------------------------
96108 26时41分48秒
108 0时1分48秒
(所影响的行数为 2 行)
*/
--如果是豪秒
select time [如果time是豪秒], cast(cast((time*1.0/1000) as int) / (60*60) as varchar) + '时' +
cast((cast((time*1.0/1000) as int) % (60*60))/60 as varchar) + '分' +
cast(cast((time*1.0/1000) as int) % 60 as varchar) + '秒'
/*
如果time是豪秒
----------- ------------------------------------------------------------------------------------------------
96108 0时1分36秒
108 0时0分0秒
(所影响的行数为 2 行)
*/
from tab
drop table tab
create table tab(time int)
insert into tab values(96108)
insert into tab values(108)
go
--如果是秒
select cast(time / (60*60) as varchar) + '时' +
cast((time % (60*60))/60 as varchar) + '分' +
cast(time % 60 as varchar) + '秒'
from tab
--如果是豪秒
select cast(cast((time*1.0/1000) as int) / (60*60) as varchar) + '时' +
cast((cast((time*1.0/1000) as int) % (60*60))/60 as varchar) + '分' +
cast(cast((time*1.0/1000) as int) % 60 as varchar) + '秒'
/*
------------------------------------------------------------------------------------------------
0时1分36秒
0时0分0秒
(所影响的行数为 2 行)
*/
from tab
drop table tab
/*
----------------------------------------------------------------------------------------------------
26小时41分钟48秒
(所影响的行数为 1 行)
*/
create table tab(time int)
insert into tab values(96108)
go
select cast(time / (60*60) as varchar) + '小时' +
cast((time % (60*60))/60 as varchar) + '分钟' +
cast(time % 60 as varchar) + '秒'
from tab
drop table tab
/*
----------------------------------------------------------------------------------------------------
26小时41分钟48秒
(所影响的行数为 1 行)
*/