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,
Thanks a lot Furcy. It works.
Regards,
Thimuth
On Sun, Dec 21, 2014 at 4:34 PM, Furcy Pin furcy@flaminem.com 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
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