Re: How to match three letter month name in Hive queries
Thanks a lot Furcy. It works. Regards, Thimuth On Sun, Dec 21, 2014 at 4:34 PM, Furcy Pin wrote: > Hi Thimut, > > I believe that the UDF unix_timestamp uses the java class SimpleDateFormat. > http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html > > From the doc, you can see that "m" denotes a minute while "M" denotes a > month. > For your problem, "-MMM-dd" should do the trick. > > Regards, > > Furcy > > > 2014-12-21 4:36 GMT+01:00 Thimuth Amarakoon : > >> Hi, >> >> How can we match a date value like *2014-Dec-20* in unix_timestamp()? >> The pattern *-MM-dd* matches 2014-12-20 format. But -mmm-dd or >> -m-dd is not doing the trick for matching the month name. >> >> Thanks and regards, >> Thimuth >> > >
Re: How to match three letter month name in Hive queries
Hi Thimut, I believe that the UDF unix_timestamp uses the java class SimpleDateFormat. http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html >From the doc, you can see that "m" denotes a minute while "M" denotes a month. For your problem, "-MMM-dd" should do the trick. Regards, Furcy 2014-12-21 4:36 GMT+01:00 Thimuth Amarakoon : > Hi, > > How can we match a date value like *2014-Dec-20* in unix_timestamp()? The > pattern *-MM-dd* matches 2014-12-20 format. But -mmm-dd or > -m-dd is not doing the trick for matching the month name. > > Thanks and regards, > Thimuth >
How to match three letter month name in Hive queries
Hi, How can we match a date value like *2014-Dec-20* in unix_timestamp()? The pattern *-MM-dd* matches 2014-12-20 format. But -mmm-dd or -m-dd is not doing the trick for matching the month name. Thanks and regards, Thimuth