How to convert a string 0 x0000000000006594 to timestamp type

, we are doing the MSSQL data import oracle, want to do with the timestamp incremental import, encountered problem is the last time the import biggest timestamp saved as a string, can't do a query into MSSQL timestamp type, CONVERT (timestamp, '0 x0000000000006594) doesn't work, so can't check the data