MONTHNAME

Returns the name of the month of a datetime value.

Syntax

MONTHNAME(expr)

Example

SELECT MONTHNAME('2020-06-20 11:20:52.000321')

Returns: June