MONTH

Returns the month (1-12) for the given date.

Syntax

MONTH(date)

Arguments

date	Date value to extract the month. Use the format (year, month, day)

Example

MONTH(DATE(1998,10,12)) returns 10.