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



Teradata.Client.Provider Namespace > TdPeriodTime Structure : LeftDiff Method
The left TdPeriodTime operand.
The right TdPeriodTime 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 TdPeriodTime, _
   ByVal right As TdPeriodTime _
) As TdPeriodTime
'Usage
 
Dim left As TdPeriodTime
Dim right As TdPeriodTime
Dim value As TdPeriodTime
 
value = TdPeriodTime.LeftDiff(left, right)
public static TdPeriodTime LeftDiff( 
   TdPeriodTime left,
   TdPeriodTime right
)
public:
static TdPeriodTime LeftDiff( 
   TdPeriodTime left,
   TdPeriodTime right
) 

Parameters

left
The left TdPeriodTime operand.
right
The right TdPeriodTime operand.

Return Value

A TdPeriodTime 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 TdPeriodTime.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 = TdPeriodTime.Null

The left and right operands do not overlap.

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

Ldiff = TdPeriodTime.Null

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

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

Ldiff = TdPeriodTime.Null

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

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

Ldiff = TdPeriodTime.Null

The left and right operands do not overlap.

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

Ldiff = TdPeriodTime.Null

The beginning bounds of both operands are equal. A period cannot be created whose beginning 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

TdPeriodTime Structure
TdPeriodTime Members