MySQL Date/Time month() Function

The month() is a MySQL date/time function. It is used to get the value of month from given datetime or time.

Syntax

Parameter:

Date_value: datetime or time value for getting hour.

Returns:

This function returns the month portion of a date value.

Example 1

Output:

Example 2

Output: