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



Teradata.Client.Provider Namespace > TdPeriodTimestampWithTimeZone Structure : Intersect Method
The left TdPeriodTimestampWithTimeZone operand.
The right TdPeriodTimestampWithTimeZone operand.
The intersection between the left and right operands is calculated.
Syntax

Parameters

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

Return Value

A period that is the intersection between the left and right operands is returned.
Remarks

A TdPeriodTimestampWithTimeZone.Null is returned under the following scenarios:

It is required that the UTC Offset for both the left and right operands be the same.

In the following examples (bL, eL) is the left operand and (bR, eR) is the right operand.

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

Intersection = null

The ending bound of the first operand is the same as the starting bound of the second operand, eL = bR.

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

Intersection = null

The periods do not intersect.

Requirements
ProductVersionsPlatforms
.NET6, 7Windows, Linux, MacOS
.NET Framework4.6.2, 4.7, 4.7.1, 4.7.2, 4.8Windows
.NET Standard2.0Windows, Linux, MacOS
See Also

Reference

TdPeriodTimestampWithTimeZone Structure
TdPeriodTimestampWithTimeZone Members