SQLServer right函數 從右側截取指定位元的字串

標籤：varchar   nbsp   rtti   arch   color   取字串   span   截取字串   sqlserver   

right(欄位名,n)

sql從右側截取字串。n代表從右側截取的位元。

 

SELECT RIGHT(‘123456‘, 4)SELECT LEFT(‘123456‘, 4)

--------------------------------------------------------------

舉個栗子：

declare @starttime as datetimedeclare @endtime as datetimeset @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)

 

SQLServer right函數 從右側截取指定位元的字串