数据库日期和十六进制互转

select CAST(0x0000AAF800000000 AS DateTime)

declare @dt datetime = '2019-11-1 00:00:00.000'
select convert(varbinary(8), @dt) as date_time_binary