Advertisement
Hippolito

Untitled

Sep 18th, 2019
165
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.59 KB | None | 0 0
  1.         CASE
  2.            WHEN DATEDIFF(MINUTE,a.start_time, a.end_time) = 0
  3.              THEN '0 min' + ' ' + CAST(CAST(a.execution_duration/1000.0 AS NUMERIC(6,2)) AS VARCHAR(20)) + ' ' + N'сек'
  4.            ELSE  
  5.                 CASE
  6.                   WHEN DATEDIFF(MINUTE,a.start_time, a.end_time) > 60
  7.                     THEN CAST(DATEDIFF(MINUTE,a.start_time, a.end_time) / 60 AS VARCHAR(20)) + ' ' + N'ч.' + CAST(DATEDIFF(MINUTE,a.start_time, a.end_time) % 60 AS VARCHAR(20)) + ' ' + N'мин.'
  8.                   ELSE CAST(DATEDIFF(MINUTE,a.start_time, a.end_time) AS VARCHAR(20)) + ' ' + N'мин.'
  9.                 END
  10.         END AS [Продолжительность]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement