Can you show me exact syntax, how to do this? It will be of great help to me. Thanks.
*Raihan Jamal* On Wed, Jul 18, 2012 at 1:14 PM, Paul Mackles <pmack...@adobe.com> wrote: > That timestamp is in millseconds but the hive date functions expect > seconds. Try dividing by 1000 first. > > From: Raihan Jamal <jamalrai...@gmail.com> > Reply-To: "user@hive.apache.org" <user@hive.apache.org> > To: "user@hive.apache.org" <user@hive.apache.org> > Subject: Converting Timestamp to Date omly > > This is the Timestamp *1338674299000* > > > > When I tried converting the above timestamp into the date only. > > I got this below result for date by using this syntax- > *to_date(from_unixtime(cast(prod_and_ts.timestamps > as BIGINT)))* > > > > *44390-11-25* > > * > * > > * > * > > Anything wrong I am doing in my syntax? > > > *Raihan Jamal* > >
