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

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

See Also

Reference

TdPeriodTimestampWithTimeZone Structure
TdPeriodTimestampWithTimeZone Members