HIVE Date Functions from_unixtime: This function converts the number of seconds from unix epoch (1970-01-01 00:00:00 UTC) to a STRING that represents the TIMESTAMP of that moment in the current system time zone in the format of “1970-01-01 00:00:00”. The following example returns the current date including the time.
hive> SELECT FROM_UNIXTIME(UNIX_TIMESTAMP());
Time taken: 0.153 seconds, Fetched: 1 row(s)
from_utc_timestamp This function assumes that the string in the first expression is UTC and then, converts that string to the […]