Advertisement
Guest User

Untitled

a guest
Dec 18th, 2014
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. Date
  2. 1021165435
  3. 1021215439
  4. 1021215441
  5. 1021162126
  6. 1021162122
  7. 1021212135
  8. 1021162137
  9. 1021212136
  10. 1021213136
  11.  
  12. select [Hora origen ] ,
  13. nHora= convert(time ,
  14. right( '0' + convert(varchar, [Hora origen] / 10000 ) , 2 )
  15. + ':'
  16. + right( '0' + (([Hora origen]-([Hora origen] % 100))% 10000)/100 , 2 )
  17. + ':'
  18. + right( '0' + convert(varchar, [Hora origen] % 10000 ) , 2 )
  19. )
  20. from Trx_tj$;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement