how do you convert varchar to timestamp

Solutions on MaxInterview for how do you convert varchar to timestamp by the best coders in the world

showing results for - "how do you convert varchar to timestamp"
Lucas
06 Feb 2017
1declare @hexstring varchar(max);
2set @hexstring = '0xabcedf012439';
3select CONVERT(varbinary(max), @hexstring, 1);
4
5set @hexstring = 'abcedf012439';
6select CONVERT(varbinary(max), @hexstring, 2);
7