Re: How to match three letter month name in Hive queries

2014-12-21 Thread Thimuth Amarakoon
e 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 to match three letter month name in Hive queries

2014-12-20 Thread 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