# MONTH

Extracts the month from the given datetime.

## Syntax

```sql
MONTH ( dateobj )

```

## Arguments

* dateobj: a valid date, datetime, or parsable date string.

## Return Type

Integer

## Examples

```sql
SELECT MONTH('2009-02-13');

```

```output

+---------------------+
| MONTH('2009-02-13') |
+---------------------+
|                   2 |
+---------------------+

```

**Related Topics**

* [MONTHNAME](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/monthname.md)
* [DAY](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/day.md)
* [YEAR](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/year.md)

***

Modified at: May 31, 2023

Source: [/cloud/reference/sql-reference/date-and-time-functions/month/](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/month/)

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