Is there any function in hive that converts epoch time to standard date?

Question

to_date function takes this "1970-11-01 00:00:00" as an input and returns "1970-11-01".

But I have epoch time as an input. How do I convert it to standard date format?

There is a function to convert standard date to unix epoch time but not the other way.

Any help is appreciated.

Thanks priyank

Answer 1

From: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions

from_unixtime(bigint unixtime[, string format])