We are developing a reporting tool build on Power BI and we're down to one issue to get the data into SQL. Some of their SQL queries return startedatetime and enddatetime in a 32-bit hex (non-readable) format. A startdatetime might read 0x9c8d322a77010000 for example. Is there a way to convert this into a readable timestamp?
The attached screenshot shows the query the developer ran (using the 64-bit IBM Informix ODBC driver) from SQL Tools and the returned data with the 32-bit (unreadable) timestamp.
Thanks,
Steve in Dallas