Sample Header Ad - 728x90

64 bit hexadecimal AS Date in SQL

0 votes
2 answers
2025 views
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))))
Asked by mouliin (530 rep)
Nov 25, 2020, 12:43 PM
Last activity: Nov 25, 2020, 02:46 PM