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



Teradata.Client.Provider Namespace > TdPeriodTimestampWithTimeZone Structure : Normalize Method
The left TdPeriodTimestampWithTimeZone operand.
The right TdPeriodTimestampWithTimeZone operand.
A TdPeriodTimestampWithTimeZone 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

Parameters

left
The left TdPeriodTimestampWithTimeZone operand.
right
The right TdPeriodTimestampWithTimeZone operand.

Return Value

A TdPeriodTimestampWithTimeZone is returned whose period includes both operands.
Remarks

It is required that the UTC Offset of both the left and right operand be the same.

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

TdPeriodTimestampWithTimeZone Structure
TdPeriodTimestampWithTimeZone Members