How to get month name from date in Presto

Question

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?

Any reason why it's a -1 for the question? I guess I've given details in the question after doing research. — stack_pointer is EXTINCT, Nov 20 '17 at 18:50
Please specify any code you have. From documentation, https://prestodb.io/docs/current/functions/datetime.html, there is the `%M` specifier that should do what you want. — Dalton Cézane, Nov 20 '17 at 18:53

score 5 · Accepted Answer · answered Nov 24 '17 at 06:37

5

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

answered Nov 24 '17 at 06:37

Kai Sasaki

667
4
13

score 2 · Answer 2 · answered Oct 10 '19 at 19:13

2

Using Presto , you can also use following function: -

SELECT extract(MONTH from CURRENT_DATE) Month

And Output would look like:-

answered Oct 10 '19 at 19:13

SUKUMAR S

187
2
8

score 0 · Answer 3 · answered May 12 '23 at 00:11

0

You can also use the date_trunc function

SELECT date_trunc('month', date) as Month

answered May 12 '23 at 00:11

Ankit Gadodia

7
2

1

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community May 12 '23 at 15:32

How to get month name from date in Presto

3 Answers3