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



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

Parameters

left
The left TdPeriodTimestamp operand.
right
The right TdPeriodTimestamp operand.

Return Value

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

The left and right operands do not overlap.

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

Ldiff = TdPeriodTimestamp.Null

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

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

Ldiff = TdPeriodTimestamp.Null

The left and right operands do not overlap.

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

Ldiff = TdPeriodTimestamp.Null

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

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

TdPeriodTimestamp Structure
TdPeriodTimestamp Members

 

 

© 2005-2025 Teradata. All rights reserved.