Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Date
- 1021165435
- 1021215439
- 1021215441
- 1021162126
- 1021162122
- 1021212135
- 1021162137
- 1021212136
- 1021213136
- select [Hora origen ] ,
- nHora= convert(time ,
- right( '0' + convert(varchar, [Hora origen] / 10000 ) , 2 )
- + ':'
- + right( '0' + (([Hora origen]-([Hora origen] % 100))% 10000)/100 , 2 )
- + ':'
- + right( '0' + convert(varchar, [Hora origen] % 10000 ) , 2 )
- )
- from Trx_tj$;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement