Forum Discussion
Binary timestamp conversion
hi, AnnevBodegom
You may refer to this post:
https://community.powerbi.com/t5/Desktop/SQL-timestamp-reads-as-binary-How-to-convert/td-p/461325
If not your case, please share some data sample and expected output.
Best Regards,
Lin
Thank you for the reply, Lin v-lili6-msft.
I've read the post you linked below and tried the suggested solution. I have implemented the solution addressed by Greg_Deckler about converting from hexadecimal with functions successfully in the past. Unfortunately, I cant seem to get anything working on this matter.
The sample data is like this: AAAAAAN1STg=
which is 8 bit binary. I'm trying to convert it to a timestamp: 15-03-2019 10:44:33
Could my locale settings be the issue, since I'm in the Netherlands?
Greetings,
Anne