Thanks for the suggestion. I will use BIGINT now.
On Fri, Jul 20, 2012 at 3:48 PM, [email protected] < [email protected]> wrote: > BIGINT is 8 bytes whereas INT is 4 bytes. Timestamps are usually of "long" > type. To avoid loss of precision, I would recommend BIGINT. > > > On Fri, Jul 20, 2012 at 4:52 PM, Tech RJ <[email protected]> wrote: > >> 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? >> >> >> >> >> > > > -- > Swarnim >
