right(字段名, n)
sql 从右侧截取字符串. n 代表从右侧截取的位数.
- SELECT RIGHT('123456', 4)
- SELECT LEFT('123456', 4)
- --------------------------------------------------------------
举个栗子:
- declare @starttime as datetime
- declare @endtime as datetime
- set @starttime = GETDATE()--'2018-06-19 17:08:02.000'
- set @endtime = '2018-06-20 17:08:02.000'
- select right('00'+ cast(cast(datediff(ss ,@starttime,@endtime) / 3600 as int) as varchar),2) + ':' +
- right('00'+ cast(cast(datediff(ss ,@starttime,@endtime) % 3600 / 60 as int) as varchar),2) + ':' +
- right('00'+ cast(cast(datediff(ss ,@starttime,@endtime) % 60 as int) as varchar),2)
来源: http://www.bubuko.com/infodetail-2651333.html