Send feedback on this topic.
Teradata.Client.Provider
LeftDiff Method (TdPeriodTimeWithTimeZone)



Teradata.Client.Provider Namespace > TdPeriodTimeWithTimeZone Structure : LeftDiff Method
The left TdPeriodTimeWithTimeZone operand.
The right TdPeriodTimeWithTimeZone operand.
The period whose beginning and ending bounds are defined as the beginning bound of the left operand and the beginning bound of the right operand when the operands overlap.
Syntax
'Declaration
 
Public Shared Function LeftDiff( _
   ByVal left As TdPeriodTimeWithTimeZone, _
   ByVal right As TdPeriodTimeWithTimeZone _
) As TdPeriodTimeWithTimeZone
'Usage
 
Dim left As TdPeriodTimeWithTimeZone
Dim right As TdPeriodTimeWithTimeZone
Dim value As TdPeriodTimeWithTimeZone
 
value = TdPeriodTimeWithTimeZone.LeftDiff(left, right)

Parameters

left
The left TdPeriodTimeWithTimeZone operand.
right
The right TdPeriodTimeWithTimeZone operand.

Return Value

A TdPeriodTimeWithTimeZone is returned that includes the portion of the left operand that exists before the beginning of the right operand when the operands overlap.
Remarks

A TdPeriodTimeWithTimeZone.Null is returned under the following scenarios:

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

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

Ldiff = TdPeriodTimestampWithTimeZone.Null

The left and right operands do not overlap.

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

Ldiff = TdPeriodTimestampWithTimeZone.Null

The beginning bound of the right operand is greater than the beginning bound of the left.

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

Ldiff = TdPeriodTimestampWithTimeZone.Null

The left and right operands do not overlap.

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

Ldiff = TdPeriodTimestampWithTimeZone.Null

The beginning bounds of both operands are equal. A period cannot be created whose beginning and ending bounds are equal.

Requirements
ProductVersionsPlatforms
.NET2.1, 3.1, 6Windows, Linux, MacOS
.NET Framework4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8Windows
.NET Standard2.0Windows, Linux, MacOS
See Also

Reference

TdPeriodTimeWithTimeZone Structure
TdPeriodTimeWithTimeZone Members