# MONTHNAME

The `MONTHNAME()` function extracts the name of the month from the given datetime.

## Syntax

```
MONTHNAME ( dateobj )

```

## Arguments

* `dateobj`: A valid date, datetime, or parsable date string.

## Return Type

String

## Examples

```sql
SELECT MONTHNAME('2009-02-13 23:31:30');

```

```output

+----------------------------------+
| MONTHNAME('2009-02-13 23:31:30') |
+----------------------------------+
| February                         |
+----------------------------------+

```

**Related Topics**

* [MONTH](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/month.md)

***

Modified at: June 26, 2026

Source: [/db/v9.1/reference/sql-reference/date-and-time-functions/monthname/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/monthname/)

(An index of the documentation is available at /llms.txt)