QUARTERS_SUB

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_SUB(<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_sub("2020-01-31 02:02:02", 1);

+---------------------------------------------------------------+
| quarters_sub(cast('2020-01-31 02:02:02' as DATETIMEV2(0)), 1) |
+---------------------------------------------------------------+
| 2019-10-31 02:02:02                                           |
+---------------------------------------------------------------+