How to get month name abbr instead of month number in Hive
11,786
Use MMM
with date_format
function.
date_format(date_field,'MMM')
To get the full month name, use
date_format(date_field,'MMMMM')
Comments
-
AJm almost 2 years
I want month name instead of month number from a Date passed in HIVE
I am doing
select Month(date_field) from <tablename>;
this gives me a month number. How to get month names ??