Send feedback on this topic.
Teradata.Client.Provider
RightDiff Method (TdPeriodTimestampWithTimeZone)



Teradata.Client.Provider Namespace > TdPeriodTimestampWithTimeZone Structure : RightDiff Method
The left TdPeriodTimestampWithTimeZone operand.
The right TdPeriodTimestampWithTimeZone operand.
The period that contains the portion from the ending bound of the left operand to the ending bound of the right when the operands overlap.
Syntax

Parameters

left
The left TdPeriodTimestampWithTimeZone operand.
right
The right TdPeriodTimestampWithTimeZone operand.

Return Value

A TdPeriodTimestampWithTimeZone is returned that contains the period that begins from the end of the left operand to the end of the right when the operands overlap.
Remarks

It is required that the UTC Offset of both the left and right operand be the same.

A TdPeriodTimestampWithTimeZone.Null is returned under the following scenarios:

In the following examples the left and right operands are defined as (bL, eL) and (bR, eR), respectively.

Example Comments
             |-------|-----|-----|
             bL      bR    eL    eR
                           |=====|
             
Rdiff = (eL, eR)
             |-------|------|-----|
             bR      bL     eL    eR
                            |=====|
             
Rdiff = (eL, eR)
             |------|------|------|
             bL     bR     eR     eL
             

Rdiff = null

The left operand's ending bound is greater than the ending bound of the right operand.

             |------|-----|-----|
             bL     eL    bR    eR
             

Rdiff = null

The left and right operands do not overlap.

             |------|-----|-----|
             bR     eR    bL    eL
             

Rdiff = null

The left and right operands do not overlap.

             |-------|-------|
             bL      bR    eL eR
             

Rdiff = null

The ending bounds are equal. In other words, a period cannot be defined whose starting and ending bounds are equal.

Requirements

Target Platforms: Windows 8.1, Windows 10, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019

See Also

Reference

TdPeriodTimestampWithTimeZone Structure
TdPeriodTimestampWithTimeZone Members