How to get month name from date in Presto
19,949
Solution 1
As commented, Presto provides date_format
function which is compatible with MySQL one. %M
will tell you the exact month name of your timestamp. For example:
SELECT date_format(timestamp '2017-11-21 12:00:00', '%M') month_name
Solution 2
Using Presto , you can also use following function: -
SELECT extract(MONTH from CURRENT_DATE) Month
And Output would look like:-
Author by
stack_pointer is EXTINCT
Updated on August 20, 2022Comments
-
stack_pointer is EXTINCT almost 2 years
I use Presto and I do not know the function to get MONTH's name from a date column. I can get MONTH number using
MONTH(<date>)
function but I'm not able to get MONTH name.I've seen ways where a list of month names is manually created and the number is matched over with the list to obtain the name. Is there a better approach to use any known function in Presto?
-
stack_pointer is EXTINCT over 6 yearsAny reason why it's a -1 for the question? I guess I've given details in the question after doing research.
-
Dalton Cézane over 6 yearsPlease specify any code you have. From documentation, prestodb.io/docs/current/functions/datetime.html, there is the
%M
specifier that should do what you want.
-