MONTHNAME()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Xpand
Topics on this page:
Overview
Returns the month name of a date.
USAGE
MONTHNAME(date)
Argument Name | Description |
|---|---|
| The |
DETAILS
MONTHNAME() is a date-time function that returns the month name of a date or datetime expression.
The names returned are the full names in the current locale, such as January to December in English.
A NULL is returned for the 0000-00-00 date or a NULL argument.
EXAMPLES
SELECT MONTHNAME('2020-02-29'),
MONTHNAME('0000-00-00'),
MONTHNAME(NULL);
+-------------------------+-------------------------+-----------------+
| MONTHNAME('2020-02-29') | MONTHNAME('0000-00-00') | MONTHNAME(NULL) |
+-------------------------+-------------------------+-----------------+
| February | NULL | NULL |
+-------------------------+-------------------------+-----------------+