Forum Discussion
Solved
convert oracle time
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 re...
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
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