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



Teradata.Client.Provider Namespace > TdPeriodTimestamp Structure : Normalize Method
The left TdPeriodTimestamp operand.
The right TdPeriodTimestamp operand.
A TdPeriodTimestamp that contains a period that encompasses both periods of the left and right operands. The beginning bound is defined as the minimum of left and right beginning bounds, and the ending bound is defined as the maximum of the left and right ending bounds. The operands must either meet or overlap.
Syntax
'Declaration
 
Public Shared Function Normalize( _
   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.Normalize(left, right)
public static TdPeriodTimestamp Normalize( 
   TdPeriodTimestamp left,
   TdPeriodTimestamp right
)
public:
static TdPeriodTimestamp Normalize( 
   TdPeriodTimestamp left,
   TdPeriodTimestamp right
)

Parameters

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

Return Value

A TdPeriodTimestamp is returned whose period includes both operands.
Remarks

A TdPeriodTimestamp.Null is returned under the following scenarios:

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

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

Normalize = TdPeriodTimestamp.Null

The periods do not overlap.

Requirements

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

See Also

Reference

TdPeriodTimestamp Structure
TdPeriodTimestamp Members

 

 

© 2005-2019 Teradata. All rights reserved.