How to Insert hexadecimal value(timestamp data type) from SQL Server to syapse Delta lake table as string type

Question

There is a column in SQL Server with timestamp datatype which stores hexadecimal value like '0x00000000018B8199 ' . I want to load this data into synapse delta lake table as string. I am using pipeline and data load Data from SQL Server to synapse delta lake.

I have used below query to read data using dataflow but it stores junk characters are into delta lake table.

SELECT CONVERT(varchar(100),CONVERT(varbinary(64), column1)) AS NewColumn FROM dbo.test  

Please suggest me the way hex data as a string into synapse delta lake

Answer 1

Did you try CONVERT(varchar(100), CONVERT(varbinary(64), column1), 1)?