Advertisement
Guest User

Untitled

a guest
Jul 1st, 2016
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. select datepart(hour, @t) * 10000 + datepart(minute, @t) * 100 + datepart(second, @t)
  2.  
  3. TIME HHMMSS INT
  4. 00:00:05 000005 5
  5. 00:10:00 001000 1000
  6. 01:01:00 010100 10100
  7. 10:00:00 100000 100000
  8.  
  9. Declare @Time Int = 10100
  10.  
  11. Select @Time / 10000 As HH,
  12. (@Time % 10000) / 100 As MM,
  13. ((@Time % 10000) % 100) As SS
  14.  
  15. HH MM SS
  16. 1 1 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement