网游之双绝,窝窝地小说网,arx
参考实例:
--定义变量 declare @starttime datetime declare @endtime datetime declare @hour int declare @minute int declare @second int declare @minutes varchar --为变量赋值 set @starttime = '2020-02-10 08:30:00' set @endtime = '2020-02-19 17:10:09' set @hour = datediff(hour, @starttime, @endtime) set @minute = datediff(minute, @starttime, @endtime) set @second = datediff(second, @starttime, @endtime) set @minutes = case when datepart(second, @endtime) >= datepart(second, @starttime) then cast((@minute % 60) as varchar) else cast((datediff(minute, dateadd(minute, -1, @endtime), @endtime) % 60) as varchar) end --select select [dd:hh:mm:ss] = cast((@hour / 24) as varchar) +':'+ cast((@hour % 24) as varchar) +':'+ @minutes + ':' + cast((@second % 60) as varchar), [字符串格式] = cast((@hour / 24) as varchar) +n'天 '+ cast((@hour % 24) as varchar) +n'小时 ' + @minutes + n'分钟 ' + cast((@second % 60) as varchar) + n'秒 '
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
数据库SQL---数据库、基本表、视图、索引的定义、修改、删除
在 Azure CentOS VM 中配置 SQL Server 2019 AG - (上)
在 Azure CentOS VM 中配置 SQL Server 2019 AG - (下)
网友评论