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

            SELECT
            RIGHT(‘123456‘, 4)
SELECTLEFT(‘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‘selectright(‘00‘+cast(cast(datediff(ss ,@starttime,@endtime) /3600asint) asvarchar),2) +‘:‘+right(‘00‘+cast(cast(datediff(ss ,@starttime,@endtime) %3600/60asint) asvarchar),2) +‘:‘+right(‘00‘+cast(cast(datediff(ss ,@starttime,@endtime) %60asint) asvarchar),2)