how to return date from date time using hive query code example

Example: hadoop hive get time from timestamp

from_unixtime(UNIX_TIMESTAMP(your_unix_timestamp), 'HH:mm:ss')