MySQL Date/Time quarter() Function

The quater() is a MySQL date/time function. It is used to get the quarter portion of the given date/datetime.

Syntax

Parameter:

Date_value : date or datetime for getting quarter value.

Returns:

This function returns the quarter portion of a date value.

Example 1

Output:

Example 2

Output: