Returns a character string containing the data source/specific name of the month (for example, January through December). Currently only supports English locale.

 

Example:

SELECT MONTHNAME({d '2000-09-13'}) returns
September