Send feedback on this topic.
Teradata.Client.Provider
Addition(TdPeriodTimestampWithTimeZone,TdIntervalDayToSecond) Operator



Teradata.Client.Provider Namespace > TdPeriodTimestampWithTimeZone Structure > Addition Operator : Addition(TdPeriodTimestampWithTimeZone,TdIntervalDayToSecond) Operator
A TdPeriodTimestampWithTimeZone for addition.
The TdIntervalDayToSecond that will be added to the TdPeriodTimestampWithTimeZone.
Adds the specified TdIntervalDayToSecond to a TdPeriodTimestampWithTimeZone.
Syntax

Parameters

period
A TdPeriodTimestampWithTimeZone for addition.
interval
The TdIntervalDayToSecond that will be added to the TdPeriodTimestampWithTimeZone.

Return Value

A TdPeriodTimestampWithTimeZone is returned that is the result of adding the TdIntervalDayToSecond to a TdPeriodTimestampWithTimeZone.
Exceptions
ExceptionDescription
Unable to add the specified TdIntervalDayToSecond to a TdPeriodTimestampWithTimeZone.
The TdPeriodTimestampWithTimeZone beginning bound is greater or equal to the ending bound of the period.
Remarks

If interval or period is Null a TdPeriodTimestampWithTimeZone.Null will be returned.

The TdIntervalDayToSecond will be added to both the beginning and ending bounds of the period. If the scale between the period and the interval are different, the arithmetic operation will be performed using the different scales. The result will then be truncated to match the scale of the TdPeriodTimestampWithTimeZone.

For example, if the period is "2007-10-04 12:50:56.2123-08:00", "2007-11-01 13:23:54.4435-08:00") and the interval is "200 20:40:50.654321" (200 days, 20 hours, 40 minutes, 50 seconds and 654321 microseconds), the add operation will result in a period of ("2008-04-22 09:31:46.8666-08:00", "2008-05-20 10:04:45.0978-08:00").

Requirements

Target Platforms: Windows 7, Windows 8, Windows 8.1, Windows 10, Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2

See Also

Reference

TdPeriodTimestampWithTimeZone Structure
TdPeriodTimestampWithTimeZone Members
Overload List