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> wrote: > Hi, > > Is there any Date Function which returns Full Month Name for given time > stamp. > >