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

from_unixtime(bigint unixtime[, string format])

date hadoop hive epoch

To add to the other answers, in case your epoch time value is a String column in your hive table

SELECT TO_DATE(FROM_UNIXTIME(CAST(epoch_string AS BIGINT))) FROM hive_table;

CodeHunter