QUARTERS_ADD

Description

The function adds or subtracts a specified number of quarters to/from a given date or datetime value and returns the resulting date.

Syntax

QUARTERS_ADD(<date/datetime>, <quarters>)

Parameters

Parameter	Description
<date/datetime>	The input date or datetime value, supports DATE or DATETIME types.
<quarters>	The number of quarters to add or subtract. Positive integers add quarters, while negative integers subtract quarters.

Return Value

• Returns a date value consistent with the input date type.
• If <date/datetime> is NULL, the function returns NULL.
• If <date/datetime> is an invalid date (e.g., 0000-00-00), the function returns NULL.

Example

 select quarters_add("2020-01-31 02:02:02", 1);

+---------------------------------------------------------------+
| quarters_add(cast('2020-01-31 02:02:02' as DATETIMEV2(0)), 1) |
+---------------------------------------------------------------+
| 2020-04-30 02:02:02                                           |
+---------------------------------------------------------------+