HPL/SQL is included to Apache Hive since version 2.0
HPL/SQL is included to Apache Hive since version 2.0
FROM_UNIXTIME function converts the specified number of seconds since 1970-01-01 00:00:00 to timestamp value.
Syntax:
FROM_UNIXTIME(epoch, [format])
Parameters:
Return Type:
STRING
Example:
Convert the number of seconds to timestamp value:
from_unixtime(1447141681); --- 2015-11-10 04:48:01 from_unixtime(1447141681, 'yyyy-MM-dd'); --- 2015-11-10
Compatibility: Hive.
Version: HPL/SQL 0.3.17
See also: