Hive: Convert int timestamp to date

[#1]

Given a column of type bigint, with a mili-second precision timestamp, like this 1485172800000

How can I get hive to give me a date, like this: 1/23/2017

I've done it before and I don't believe a UDF is necessary, but I can't seem to get it to work for me today.

Thanks!

[#2 · Accepted solution]

Found it on another thread: https://community.hortonworks.com/questions/69533/convert-unix-timestamp-to-timestamp-format.html

select from_unixtime(cast(time/1000 as bigint)) from table_1;