I am querying an Oracle source.
The time fields come through as a numeric.
e.g. 1486539823535 ( i think its oracles timestamp)
any idea how to convert it to a datetime stamp we can read?
Go to Solution.
foound this. works
I think you need to know how the timestamps calculated(calculate expression), then you can add a column to do reverse calculation to restore these value.
Thanks for taking the time Xiaoxin.
Yes, I was wondering if anyone knows what the oracle function does so I can reverse it.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.