We are using Hive 1.2.1, it is working. thnq On 1/16/2017 7:40 AM, Devopam Mittra wrote: hi Mahender,
I don't know your version of Hive . Please try : date_format(curren_date,'MMMMM') regards Dev On Mon, Jan 16, 2017 at 6:56 PM, Jitendra Yadav <jeetuyadav200...@gmail.com<mailto:jeetuyadav200...@gmail.com>> wrote: Ref: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions. int month(string date) Returns the month part of a date or a timestamp string: month("1970-11-01 00:00:00") = 11, month("1970-11-01") = 11. Does it fit in your requirement?. Thanks On Mon, Jan 16, 2017 at 12:21 PM, Mahender Sarangam <mahender.bigd...@outlook.com<mailto:mahender.bigd...@outlook.com>> wrote: Hi, Is there any Date Function which returns Full Month Name for given time stamp. -- Devopam Mittra Life and Relations are not binary