Hippolito

Untitled

Sep 18th, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.34 KB | None | 0 0
  1.                   WHEN DATEDIFF(MINUTE,a.start_time, a.end_time) > 60
  2.                     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'мин.'
  3.                   ELSE CAST(DATEDIFF(MINUTE,a.start_time, a.end_time) AS VARCHAR(20)) + ' ' + N'мин.'
  4.                 END
Add Comment
Please, Sign In to add comment