题目
时间包括时分秒,它们时率是
提问时间:2021-01-09
答案
declare @day int
declare @hour int
declare @min int
declare @sec int
declare @alls int
set @alls=datediff(s,'2009-11-21 00:00:00','2009-11-24 15:12:24')
set @day=@alls/86400
set @hour=(@alls-@day*86400)/3600
set @min=(@alls-@day*86400-@hour*3600)/60
set @sec=@alls-@day*86400-@hour*3600-@min*60
select CAST(@day as varchar(5))+'天'+CAST(@hour as varchar(2))+'小时'+CAST(@min as varchar(2))+'分'+CAST(@sec as varchar(2))+'秒'
declare @hour int
declare @min int
declare @sec int
declare @alls int
set @alls=datediff(s,'2009-11-21 00:00:00','2009-11-24 15:12:24')
set @day=@alls/86400
set @hour=(@alls-@day*86400)/3600
set @min=(@alls-@day*86400-@hour*3600)/60
set @sec=@alls-@day*86400-@hour*3600-@min*60
select CAST(@day as varchar(5))+'天'+CAST(@hour as varchar(2))+'小时'+CAST(@min as varchar(2))+'分'+CAST(@sec as varchar(2))+'秒'
举一反三
已知函数f(x)=x,g(x)=alnx,a∈R.若曲线y=f(x)与曲线y=g(x)相交,且在交点处有相同的切线,求a的值和该切线方程.
我想写一篇关于奥巴马的演讲的文章,写哪一篇好呢?为什么好
奥巴马演讲不用看稿子.为什么中国领导演讲要看?
想找英语初三上学期的首字母填空练习……
英语翻译
最新试题
热门考点
- 14欧姆100W×2 MAX (RMS) 500W×2
- 2从方框中选择正确的词,并用其适当形式填空:(three ,friend ,
- 3得到大量的写作练习用英语怎么说
- 4说明文语言的准确性
- 5g·cm 转矩(n·m) 扭矩(kg·m)
- 6为什么说旋转中的中子星就是脉冲星?
- 7()your test paper carefully,and some mistakes can certainly be avoided,I think
- 8已知lg3=a,lg5=b,求100^3a-2b的值.
- 9F(x)=√3sin(2x-∏/6)-cos(2x-∏/6),求函数周期与使函数取得最大值x集合
- 10what can i do to tell u how i still love 请问这句话怎么翻译?