date for sql hive code example Example: hadoop hive get time from timestamp from_unixtime(UNIX_TIMESTAMP(your_unix_timestamp), 'HH:mm:ss')