SQLServer right函数从右侧截取指定位数的字符串

时间：2018-06-20 10:11:39 收藏：0 阅读：764

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)

原文：https://www.cnblogs.com/lpl521/p/9202228.html

SQLServer right函数 从右侧截取指定位数的字符串

SQLServer right函数从右侧截取指定位数的字符串