Solved: Change binary to date from SQL DB

KBO · ‎12-02-2019

Hi,

I would like to change the binary code from my timestamp column to a date. I try Text.FromBinary but than I get a question mark symbol. Can anybody help?

KBO · ‎12-02-2019

Solved the problem - not complete but for my needs it is ok.

Used = Binary.ToList([timestamp])

Anmerkung 2019-12-02 164314.png

And than extract values.

So I have a counter, not time or date based but it works :). If somebody had a solution with date and time I will try it :).

View solution in original post

KBO · ‎12-02-2019

Solved the problem - not complete but for my needs it is ok.

Used = Binary.ToList([timestamp])

Anmerkung 2019-12-02 164314.png

And than extract values.

So I have a counter, not time or date based but it works :). If somebody had a solution with date and time I will try it :).

artemus · ‎12-02-2019

Looking at the binary value, it appears to just be the year number, since 0x7D1 is 2001

Jimmy801 · ‎12-02-2019

Hello

I don't think that this time-stamp-value can be converted to a date, because it does represent some kind of counter.

BR

Jimmy

KBO · ‎12-02-2019

So that is the problem, actually it is a counter. If I go to my PowerApp and add a value the column value changed at the end. If I change a data set in the power app the timestamp also changed and counted up. So I think it referes to the last action in the DB but how can I extract it into Power BI ...