convert oracle time

[IanCockcroft]

Hi guys,

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?

cheers

Ian

[v-shex-msft]

Hi @IanCockcroft,

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.

Regards,

Xiaoxin Sheng

[IanCockcroft]

Thanks for taking the time Xiaoxin.

Yes, I was wondering if anyone knows what the oracle function does so I can reverse it.

cheers

Ian

[IanCockcroft · Accepted solution]

Hi

foound this. works

https://community.powerbi.com/t5/Desktop/Converting-UNIX-time-to-Date-in-PowerBI-for-Desktop/m-p/132...