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 <[email protected]> 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 < > [email protected]> wrote: > >> Hi, >> >> Is there any Date Function which returns Full Month Name for given time >> stamp. >> >> > -- Devopam Mittra Life and Relations are not binary
