Support Questions

Find answers, ask questions, and share your expertise

Hive: Convert int timestamp to date

avatar
Super Collaborator

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!

1 ACCEPTED SOLUTION

avatar
Super Collaborator

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;

View solution in original post

1 REPLY 1

avatar
Super Collaborator

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;