hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Furcy Pin <>
Subject Re: How to match three letter month name in Hive queries
Date Sun, 21 Dec 2014 11:04:53 GMT
Hi Thimut,

I believe that the UDF unix_timestamp uses the java class SimpleDateFormat.

>From the doc, you can see that "m" denotes a minute while "M" denotes a
For your problem, "yyyy-MMM-dd" should do the trick.



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 *yyyy-MM-dd* matches 2014-12-20 format. But yyyy-mmm-dd or
> yyyy-m-dd is not doing the trick for matching the month name.
> Thanks and regards,
> Thimuth

View raw message