Convert a timestamp column to a varchar

To cast or convert a timestamp column to a varchar column... 2 different ways

SELECT
	MyTimeStamp,
	Replace(Upper(master.sys.fn_varbintohexstr(MyTimeStamp)),'0X','0x') as MyTimeStampToo,
	CONVERT(NVARCHAR(MAX), CONVERT(BINARY(8), MyTimeStamp), 1) as MyTimeStampAlso,
	CONVERT(NVARCHAR(MAX), CONVERT(BINARY(8), MyTimeStamp), 2) as MyTimeStampMINUS_0x
from MyTable

Returns, for example:

MyTimeStamp MyTimeStampToo MyTimeStampAlso MyTimeStampMINUS_0x
0x000000000064B166 0x000000000064B166 0x000000000064B166 000000000064B166

Notes:

Sources