hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mahender Sarangam <Mahender.BigD...@outlook.com>
Subject Re: DateFunction
Date Tue, 17 Jan 2017 23:19:28 GMT
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 <jeetuyadav200890@gmail.com<mailto:jeetuyadav200890@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.BigData@outlook.com<mailto:Mahender.BigData@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

Mime
View raw message