MySQL QUARTER Function

MySQL Quarter function is one of the Date Function, which is used to return the quarter of the year number from a given date. This function returns integer range from 1 to 4.

In this article, we will show you, How to use this MySQL Quarter function to find, which quarter does this date belongs to? with an example.

MySQL Quarter Syntax

The basic syntax of the Quarter() Function in MySQL is as shown below:

QUARTER(date or expression);

TIP: This MySQL Quarter function returns 0, if the given date argument is 0000-00-00. Or Say, it returns 0, if Zero date part was given.

MySQL Quarter function Example

The below shown queries helps you understand the use of this Quarter function. Here, we are returning the Quarter numbers from the different date expression, and the Date & time expression.

SELECT QUARTER('2016-12-22');

SELECT QUARTER('2016-07-15');

SELECT QUARTER('2016-03-15 11:22:33');

OUTPUT

Here, we are returning quarter of the year from the current date and time returned by the Now(), and CURDATE() function.

SELECT CURDATE(), QUARTER(CURDATE());

SELECT NOW(), QUARTER(NOW());

SELECT QUARTER(CURDATE() + 20), QUARTER(NOW() + 2);

OUTPUT

MySQL Quarter Function Example 2

The following query shows you, what happens when we try to return the year quarter value from a date in string format.

In this example, we are trying to return the quarter of the year from YYYYMMDD, YYMMDD, YYYYMMDDHHMMSS formats.

SELECT QUARTER(20190512);

SELECT QUARTER(750812);

SELECT QUARTER(20191112012233);

OUTPUT

Here, we are trying to return the Quarter of the Year from an invalid dates, and zero month part. That’s why, it returns NULL.

SELECT QUARTER(20190542);

SELECT QUARTER(2019-00-00);

SELECT QUARTER(CURDATE() + 45);

OUTPUT

MySQL Quarter Example 3

In this example, we will show you, how to use this Quarter function on a table. Here, we are returning the month number from the Hire Date column.

For this MySQL Quarter function demo, we are using Workbench to write a query against the customer table.

SELECT EmpID,
       FirstName,
       LastName,
       Occupation,
       YearlyIncome,
       Sales,
       HireDate,
       QUARTER(HireDate)
 FROM `MySQL Tutorial`.customer;

OUTPUT

Thank You for Visiting Our Blog