Thanks for the suggestion. I will use BIGINT now.
On Fri, Jul 20, 2012 at 3:48 PM, kulkarni.swar...@gmail.com < kulkarni.swar...@gmail.com> 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 <comptechge...@gmail.com> 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 >
