MONTH Function

Returns the numeric month from a date or datetime value.

Category:	Date and Time
Returned data type:	TINYINT

Syntax

MONTH(date | datetime)

specifies any valid expression that represents a date value.

specifies any valid expression that represents a datetime value.

Table: CUSTONLINE

The following statement illustrates the MONTH function:

Statements	Results
select month(endtime) from custonline;	9 10 10 11 12 1 1 2 3 3
select month(current_time);	10