Hello,
I hoped somebody has already worked this out so I don’t have to .
I have a Epoch Unix Timestamp value that I want to convert into normal DATETIME format in Ataccama.
e.g. 1711015200
I was expecting converted value to be 2024-03-21 10:00:00 (GMT).
But when I do a toDateTime() on it, it gives me 1970-01-20 20:16:55. So I guessed wrong.
I thought about using dateadd() but that one does not support seconds.
Any ideas?