WorkAkkaunt

Dashbord Robit

Sep 16th, 2019
181
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.29 KB | None | 0 0
  1. select
  2.     convert(datetime, cast(cast(getdate() as date) as datetime) + substring(cast(DATEADD(HOUR, -3, TimeStr) as nvarchar(255)), 0, 9), 126) as time
  3.    ,Incoming as value
  4.    ,'Входящие' as metric
  5. from [severstal_utils].[dbo].[Dashbord_DayCalls_Line1] with (nolock)
  6. order by TimeStr asc
Advertisement
Add Comment
Please, Sign In to add comment