64 bit hexadecimal AS Date in SQL I am loading a Qlikview CalData PGO XML file into a SQL table.
Dates in this XML are stored as a 64 bit HEX string and I need to convert it to a date.
How do I do that?
Example
40e58f2c4153d0f9 should be converted to 18/11/2020 09:11:29
I have seen some sample code within qlikview, which is
daystart(date($(HEX64CONVERT(ToBeDeleted))))
This value is encrypted by QlikView to prevent you from tampering with the value.

Some fields in the generated XML file i.e. &quot;LastUsed&quot;, are encrypted
for security reasons, thus cannot be converted into readable dates
using date() conversion. The generated XML files should be used for
troubleshooting only.

https://community.qlik.com/t5/Support-Knowledge-Base/Reading-PGO-contents-and-CAL-assignments-PGO-to-XML/ta-p/1710604?_ga=2.160240829.1496857553.1606312645-1955769053.1606312645
Presumably this is part of how they track and enforce their sofware licensing agreements.