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?

Silici

Any reason why it's a -1 for the question? I guess I've given details in the question after doing research. – Silici

Please 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. – Gregoriagregorian

Answer 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

Katleen

Answer 2

Using Presto , you can also use following function: -

SELECT extract(MONTH from CURRENT_DATE) Month

And Output would look like:-

Shipshape

Answer 3

You can also use the date_trunc function

SELECT date_trunc('month', date) as Month

Concubinage

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. – Crispas