22,209
社区成员
发帖
与我相关
我的任务
分享
select cy_table.begintime,
cast(floor(datediff(hour,cy_table.begintime,getdate()) ) as varchar)+'小时'+
cast((datediff(minute ,cy_table.begintime,getdate()) % 60) as varchar)+'分钟'
from cy_table
select cy_table.begintime,
(select cast (floor(datediff(hour,cy_table.begintime,getdate()) ) as varchar)+'小时'+
cast((datediff(minute ,cy_table.begintime,getdate()) % 60) as varchar)+'分钟') as 时间差
from cy_table