Converting Timestamp value to string in SQL Server

Converting Timestamp value to string/varchar in SQL Server


Question :

   How to Convert SQL Server Timestamp Column to VARCHAR ?


Answer : 

SELECT CONVERT(VARCHAR(MAX), CONVERT(VARBINARY,Timestamp_Column_Name), 1) FROM Table