Probably you meant from_unixtime(timestamp in bigint, "dd-MMM-yyyy"). "dd" vs "DD" does make a difference in the output.
-Deepesh On Wed, Jun 25, 2014 at 2:30 PM, Matouk IFTISSEN <matouk.iftis...@ysance.com > wrote: > sorry use this : from_unixtime(field_date,'DD-MMM-YYYY') > > > 2014-06-25 23:27 GMT+02:00 Matouk IFTISSEN <matouk.iftis...@ysance.com>: > > use ; unix_timestamp(field_date,'DD-MMM-YYYY') >> >> >> >> 2014-06-25 23:20 GMT+02:00 rpriaa...@gmail.com <rpriaa...@gmail.com>: >> >> Hi, >>> >>> Please can someone tell me how to change the date format in hive. >>> I need it in the format '25-JUN-2014' >>> >>> -- >>> Regards, >>> riad >>> >> >> >> >> -- >> >> *Matouk IFTISSEN | Consultant BI & Big Data [image: >> http://www.ysance.com] * >> 24 rue du sentier - 75002 Paris - www.ysance.com <http://www.ysance.com/> >> Fax : +33 1 73 72 97 26 >> *Ysance sur* :*Twitter* <http://twitter.com/ysance>* | Facebook >> <https://www.facebook.com/pages/Ysance/131036788697> | Google+ >> <https://plus.google.com/u/0/b/115710923959357341736/115710923959357341736/posts> >> | LinkedIn >> <http://www.linkedin.com/company/ysance> | Newsletter >> <http://www.ysance.com/nous-contacter.html>* >> *Nos autres sites* : *ys4you* <http://wwww.ys4you.com/>* | labdecisionnel >> <http://www.labdecisionnel.com/> | decrypt <http://decrypt.ysance.com/>* >> > > > > -- > > *Matouk IFTISSEN | Consultant BI & Big Data [image: > http://www.ysance.com] * > 24 rue du sentier - 75002 Paris - www.ysance.com <http://www.ysance.com/> > Fax : +33 1 73 72 97 26 > *Ysance sur* :*Twitter* <http://twitter.com/ysance>* | Facebook > <https://www.facebook.com/pages/Ysance/131036788697> | Google+ > <https://plus.google.com/u/0/b/115710923959357341736/115710923959357341736/posts> > | LinkedIn > <http://www.linkedin.com/company/ysance> | Newsletter > <http://www.ysance.com/nous-contacter.html>* > *Nos autres sites* : *ys4you* <http://wwww.ys4you.com/>* | labdecisionnel > <http://www.labdecisionnel.com/> | decrypt <http://decrypt.ysance.com/>* >
