Hi,
I have been battling with this for days now. If you execute the SQL below
you will get the following result: 0x3078303030303030, which is incorrect.
It looks like the conversion is more literal than I am wanting. Does anybody
know the correct way to convert a timestamp that has been stored as a char
type, back into a varbinary(8)? (vb(8) is the suggested data type for
storing timestamps)
==============================
declare @strMinTimestamp varchar(18)
declare @MinTimestamp varbinary(8)
set @strMinTimestamp = '0x000000001A017FD8'
set @MinTimestamp = convert(varbinary(8), @strMinTimestamp)
select @MinTimestamp
==============================
thanks in advance!!
Eugene