In this format, the value for numeric_term can include instances of multiplication and division.
SELECT 12/5 * INTERVAL '10-02' YEAR TO MONTH;
The numeric_term is 12/5.
The interval_primary is INTERVAL '10-02' YEAR TO MONTH.
The processing involves the following stages:
- The numeric_term 12/5 is evaluated, giving 2.4, which is truncated to 2 because the value is an integer by default.
- The interval_primary is multiplied by 2, giving '20-04'.