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



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

Parameters

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

Return Value

A TdPeriodTimeWithTimeZone is returned whose period includes both operands.
Remarks

A TdPeriodTimeWithTimeZone.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.

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
            eR                  eR
            |===================|
            

Normalize = (bL, eL)

The periods are equal. In this scenario, the period specified as the left parameter will be returned. It will be adjusted to the maximum scale between the left and right parameters.

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

Normalize = TdPeriodTimestampWithTimeZone.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

TdPeriodTimeWithTimeZone Structure
TdPeriodTimeWithTimeZone Members