How to get month name from date in Presto

function date monthcalendar presto
stack_pointer is EXTINCT picture stack_pointer is EXTINCT · Nov 20, 2017 · Viewed 14.8k times · Source

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?

Answer

Kai Sasaki picture Kai Sasaki · Nov 24, 2017

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

Related questions

Why JavaScript getTime() is not a function?

I used the following function: function datediff() { var dat1 = document.getElementById('date1').value; alert(dat1);//i get 2010-04-01 var dat2 = document.getElementById('date2').value; alert(dat2);// i get 2010-04-13 var oneDay = 24*60*60*1000; // hours*minutes*seconds*milliseconds var …

Read More
Get the weekday from a Date object or date string using JavaScript

I have a date string in (yyyy-mm-dd) format, how can I get the weekday name from it? Example: For the string "2013-07-31", the output would be "Wednesday" For today's date using new Date(), the output would be based on …

Read More
How to get date from week number & day number and year?

I'm trying to get the date from the week number, day number and year. For eg: week number = 52 day number = 4 (of week 52) year = 2013 In this case, the date should be 26-12-2013. How can I do it using PHP? I've …

Read More