question Re: Hive: Convert int timestamp to date in Archives of Support Questions (Read Only)

Hive: Convert int timestamp to date

zack_riesland — Fri, 16 Sep 2022 11:03:34 GMT

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!

zack_riesland — Sat, 11 Feb 2017 00:54:18 GMT

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