Convert column in presto from epoch to date

Asked Aug 30 '18 at 18:59

Active Aug 30 '18 at 18:59

Viewed 60 times

I tried this but that didn't work.

cast(from_unixtime('1532568232662880')) as date

Any other ideas?

asked Aug 30 '18 at 18:59

nak5120

Would it help if you remove apostrophes? Also, divide by 1000. `from_unixtime` expects a number, being number of seconds since 1970-01-01. – Piotr Findeisen Aug 30 '18 at 20:17
See also https://stackoverflow.com/q/44533502/65458 – Piotr Findeisen Aug 30 '18 at 20:19

0 Answers0