Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select datepart(hour, @t) * 10000 + datepart(minute, @t) * 100 + datepart(second, @t)
- TIME HHMMSS INT
- 00:00:05 000005 5
- 00:10:00 001000 1000
- 01:01:00 010100 10100
- 10:00:00 100000 100000
- Declare @Time Int = 10100
- Select @Time / 10000 As HH,
- (@Time % 10000) / 100 As MM,
- ((@Time % 10000) % 100) As SS
- HH MM SS
- 1 1 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement