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))))

```