MariaDB: QUARTER Function

This MariaDB tutorial explains how to use the MariaDB QUARTER function with syntax and examples.

Description

The MariaDB QUARTER function returns the quarter portion of a date value.

Syntax

The syntax for the QUARTER function in MariaDB is:

QUARTER( date_value )

Parameters or Arguments

date_value

A date or datetime value from which to extract the quarter.

Note

• The QUARTER function returns the quarter (a number from 1 to 4) given a date value.
• Dates that have a month of Jan-Mar would return 1.
• Dates that have a month of Apr-Jun would return 2.
• Dates that have a month of Jul-Sep would return 3.
• Dates that have a month of Oct-Dec would return 4.
• See also the EXTRACT, YEAR, MONTH, WEEK, DAY, HOUR, MINUTE, SECOND, and MICROSECOND functions.

Applies To

The QUARTER function can be used in the following versions of MariaDB:

• MariaDB 10

Example

Let's look at some MariaDB QUARTER function examples and explore how to use the QUARTER function in MariaDB.

For example:

SELECT QUARTER('2014-02-17');
Result: 1

SELECT QUARTER('2014-02-17 15:21:05');
Result: 1

SELECT QUARTER('2013-05-19');
Result: 2

SELECT QUARTER('2013-07-21');
Result: 3

SELECT QUARTER('2013-11-09');
Result: 4

This last QUARTER example would display the quarter portion of the current system date (current system date is returned by the CURDATE function).

SELECT QUARTER(CURDATE());