Month (number) | DATE_MONTH

Syntax

DATE_MONTH( [value = CURRENT_DATE()] )

Parameters

value
A DATE value. If the value is not a DATE, it will be converted to one with the DATE operation.

Return Value

Returns the UTC month value of the VALUE as an INTEGER

Description

Get the month value of a DATE

Examples

DATE_MONTH("2017-08-30T17:36:23.000Z") # returns 8