![[Google Cloud Documentation]](https://www.gstatic.com/devrel-devsite/prod/v0f3a5b8b76e4a120372a69044e02756e703b6140f9f1812c6e4a0407b19864b7/clouddocs/images/lockup_full_color.svg){kind=link}
![[]](https://docs.cloud.google.com/_static/clouddocs/images/icons/categories/data-analytics-color.svg){kind=link}
MONTH
Returns the month of the year for a given date.
Sample usage
MONTH(Date)
Syntax
1) Returns the month from a Date value.
MONTH( date_expression )
2) Returns the month from a compatibility mode Date value.
MONTH( X [, format_string ])
Parameters
date_expression- a Date & Time field or expression.X- a field or expression that evaluates to Text, Number, or compatibility mode Date.format_string- format forX. Optional ifXis correctly configured as a semantic date field.
Format strings for compatibility mode dates
Supported date functions accept the following input formats if X is a Textfield or expression, or compatibility mode Date:
- Any valid strptime format is accepted.
'BASIC':%Y/%m/%d-%H:%M:%S'DEFAULT_DASH':%Y-%m-%d [%H:%M:%S]'DEFAULT_SLASH':%Y/%m/%d [%H:%M:%S]'DEFAULT_DECIMAL':%Y%m%d [%H:%M:%S]'RFC_1123':for example, Sat, 24 May 2008 20:09:47 GMT'RFC_3339':for example, 2008-05-24T20:09:47Z'DECIMAL_DATE':same as'DEFAULT_DECIMAL'
Supported time functions accept the following input format if X is a Number field or expression:
'SECONDS':seconds since Epoch'MILLIS':milliseconds since Epoch'MICROS':microseconds since Epoch'NANOS':nanoseconds since Epoch'JULIAN_DATE':days since Epoch
Examples
| Example formula | Input | Output |
|---|---|---|
MONTH(Date) |
Jan 1, 2019 | January |
MONTH(Date as Text, 'BASIC') |
2019/01/01-09:40:45 | January |
MONTH(Date as Number, 'SECONDS') |
1561784874 | June |
| |
1562004058620 | July |
Notes
This function works with both compatibility mode dates and upgraded Date and Date & Time data types.