Thanks Vijay, Yes it worked. Can you also take a look into one of my other post subject title *TOP 10.*
*Raihan Jamal* On Tue, Jul 10, 2012 at 1:41 PM, Vijay <tec...@gmail.com> wrote: > to_date(from_unixtime(cast(timestamps as int))) > > On Tue, Jul 10, 2012 at 1:33 PM, Raihan Jamal <jamalrai...@gmail.com> > wrote: > > I need only the date not the hours and second, so that is the reason I > was > > using to_date and from_unxitime() take int as parameter and timestamps > is a > > string in this case. > > > > > > > > > > Raihan Jamal > > > > > > > > On Tue, Jul 10, 2012 at 1:28 PM, Vijay <tec...@gmail.com> wrote: > >> > >> You need to use from_unixtime() > >> > >> On Tue, Jul 10, 2012 at 1:01 PM, Raihan Jamal <jamalrai...@gmail.com> > >> wrote: > >> > Here timestamps is a string and I always get NULL in the second column > >> > when > >> > I try to get date out of the timestamp. Anything wrong I am doing? > >> > > >> > > >> > select A.timestamps, to_date(A.timestamps) from > >> > (select user_id, prod_and_ts.product_id as product_id, > >> > prod_and_ts.timestamps as timestamps from testingtable2 lateral view > >> > explode(purchased_item) exploded_table as prod_and_ts) A; > >> > > >> > > >> > This is the Output I am getting always. > >> > > >> > 1004941621 NULL > >> > 1005268799 NULL > >> > 1061569397 NULL > >> > 1005542471 NULL > >> > > >> > > >> > > >> > Raihan Jamal > >> > > > > > >