By default hive displays in UTC. If you want to use specific timestamp,you can run below command   SELECT from_utc_timestamp(cast(from_unixtime(cast(1623943533 AS bigint)) as TIMESTAMP),"Asia/Kolkata") ; ... View more