You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Mahender Sarangam <Ma...@outlook.com> on 2017/01/16 12:21:53 UTC
DateFunction
Hi,
Is there any Date Function which returns Full Month Name for given time
stamp.
Re: DateFunction
Posted by Mahender Sarangam <Ma...@outlook.com>.
Hi Jitendra,
Wr are actually looking for full month name not just month number
On 1/16/2017 5:26 AM, Jitendra Yadav wrote:
month(string date)
Re: DateFunction
Posted by Mahender Sarangam <Ma...@outlook.com>.
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 <je...@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 <Ma...@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
Re: DateFunction
Posted by Devopam Mittra <de...@gmail.com>.
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 <je...@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> wrote:
>
>> Hi,
>>
>> Is there any Date Function which returns Full Month Name for given time
>> stamp.
>>
>>
>
--
Devopam Mittra
Life and Relations are not binary
Re: DateFunction
Posted by Jitendra Yadav <je...@gmail.com>.
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> wrote:
> Hi,
>
> Is there any Date Function which returns Full Month Name for given time
> stamp.
>
>