Is there any function in hive that converts epoch time to standard date?
12,758
From: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions
from_unixtime(bigint unixtime[, string format])
Related videos on Youtube
07 : 16
Excel 2013 Quick Tip: Convert Unix (Epoch) time in Excel
01 : 18
Excel formula : Convert Unix time to real time/date
06 : 19
Convert Epoch/ Unix time to datetime in Power Query in one step!
19 : 21
Hive Tutorial - 16 : Hive Functions | Unix Timestamp Functions | Hive Timestamp Functions
21 : 57
Hive Date Functions
56 : 07
Date and Time in Java using Unix Epoch Time
03 : 12
Hive Functions - Unix Timestamp Functions
06 : 01
Hive Functions - Date Arithmetic Functions
Author by
priyank
Updated on June 07, 2022Comments
-
priyank almost 2 years
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