cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
Walkthrough Wednesdays
193
Views
0
Helpful
0
Replies
STEVE GLICK
Beginner

Format of start/enddatetime 8-byte hex value returned from query

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

0 REPLIES 0
Content for Community-Ad

Spotlight Awards 2021