That timestamp is in millseconds but the hive date functions expect seconds. Try dividing by 1000 first.
From: Raihan Jamal <[email protected]<mailto:[email protected]>> Reply-To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Subject: Converting Timestamp to Date omly This is the Timestamp 1338674299000 When I tried converting the above timestamp into the date only. I got this below result for date by using this syntax- to_date(from_unixtime(cast(prod_and_ts.timestamps as BIGINT))) 44390-11-25 Anything wrong I am doing in my syntax? Raihan Jamal
