Each of the interval provider types support the following arithmetic operations:

Null Values

If any of the interval operands are Null the result of all arithmetic operations is a Null interval.

Interval Precision

All interval addition, subtraction and multiplication arithmetic operations will create a resultant interval with a maximum precision. The maximum precision for all intervals is 4 (four significant digits). All interval division arithmetic operations will create a resultant interval with the same precision as the interval dividend. The divisor must always be a numeric value.

Interval Scale

All arithmetic operations will return an interval with a scale that is the greatest of either one of the interval operands. In operations with an interval and an integer, the scale will match the interval scale.

This example illustrates the resulting interval precision and scale from intervals that contain different precision and scale.

    // Create an interval of 1 day, 20 hours, 10 minutes, 30 seconds and 25 microseconds
    //   with a precision of 3 and a scale of 5
    TdIntervalDayToSecond dts = new TdIntervalDayToSecond(1, 20, 10, 30, 20);

    // Multiply by 200
    TdIntervalDayToSecond result = dts * 200;

    // Print out the result
    Console.WriteLine("The result of the multiplication is : {0}", result);

    // The output is: "The result of the multiplication is –> 368 03:00:00.00400"
    // The result has a precision of 4 and and scale of 5     // Add intervals with different precision and scale
    // Create an interval of 100 days, 20 hours, 10 minutes, 30 seconds and 2 microseconds
    //   with a precision of 3 and a scale of 6
    TdIntervalDayToSecond left = new TdIntervalDayToSecond(100, 20, 10, 30, 2);

    // Create an interval of 1 day, 15 hours, 1 minute, 30 seconds and 40000 microseconds
    //   with a precision of 1 and a scale of 2
    TdIntervalDayToSecond right = new TdIntervalDayToSecond(1, 15, 1, 30, 40000);

    // Add left and right
    TdIntervalDayToSecond result2 = left + right;

    // Print out the result
    Console.WriteLine("The result of the addition is : {0}", result2);

    // The output is: "The result of the addition is –> 102 11:12:00.040002"
    // The result has a precision of 4 and and scale of 6

Examples of Interval Arithmetic

Arithmetic Operations Among Different Intervals

Addition and subtraction arithmetic operations are supported among different interval types through support of implicit conversions - Interval Implicit Conversions.

The following are some examples of addition and subtraction of differing interval types:

Arithmetic Interval Operations and Other Provider Specific Types

Interval arithmetic addition and subtraction operations are supported in the following provider specific types:

• TdPeriodDate
• TdPeriodTime
• TdPeriodTimeWithTimeZone
• TdPeriodTimestamp
• TdPeriodTimestampWithTimeZone
• TdDate
• TdTime
• TdTimeWithTimeZone
• TdTimestamp
• TdTimestampWithTimeZone

Provider specific types that only support time (TdTime, TdTimeWithTimeZone, TdPeriodTime, TdPeriodTimeWithTimeZone) will only support interval arithmetic operations with the following interval types:

• TdIntervalDayToSecond
• TdIntervalDayToMinute
• TdIntervalDayToHour
• TdIntervalDay
• TdIntervalHourToSecond
• TdIntervalHourToMinute
• TdIntervalHour
• TdIntervalMinuteToSecond
• TdIntervalMinute
• TdIntervalSecond