Re: Converting timestamp to date format

2012-07-20 Thread Techy Teck
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

Re: Converting timestamp to date format

2012-07-20 Thread kulkarni.swar...@gmail.com
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 wrote: > What is the difference between these two? Trying to convert timestamps to > full date format. The only differen