hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tech RJ <comptechge...@gmail.com>
Subject Converting timestamp to date format
Date Fri, 20 Jul 2012 21:52:22 GMT
What is the difference between these two? Trying to convert timestamps to
full date format. The only difference is BIGINT and INT
*
*
from_unixtime(cast(prod_and_ts.timestamps as *BIGINT*))
*
*
*OR*

from_unixtime(cast(prod_and_ts.timestamps as *INT*))



Which one should I use to get accurate result?

Mime
View raw message