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
'Declaration
 
Public Shared Function Normalize( _
   ByVal left As TdPeriodTimestampWithTimeZone, _
   ByVal right As TdPeriodTimestampWithTimeZone _
) As TdPeriodTimestampWithTimeZone
'Usage
 
Dim left As TdPeriodTimestampWithTimeZone
Dim right As TdPeriodTimestampWithTimeZone
Dim value As TdPeriodTimestampWithTimeZone
 
value = TdPeriodTimestampWithTimeZone.Normalize(left, right)
public static TdPeriodTimestampWithTimeZone Normalize( 
   TdPeriodTimestampWithTimeZone left,
   TdPeriodTimestampWithTimeZone right
)
public:
static TdPeriodTimestampWithTimeZone Normalize( 
   TdPeriodTimestampWithTimeZone left,
   TdPeriodTimestampWithTimeZone right
)

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
ProductVersionsPlatforms
.NET2.1, 3.1, 6Windows, Linux, MacOS
.NET Framework4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8Windows
.NET Standard2.0Windows, Linux, MacOS
See Also

Reference

TdPeriodTimestampWithTimeZone Structure
TdPeriodTimestampWithTimeZone Members

 

 

© 2005-2022 Teradata. All rights reserved.