Send feedback on this topic.
Teradata.Client.Provider
Subtraction(TdPeriodTimestampWithTimeZone,TdIntervalYearToMonth) Operator



Teradata.Client.Provider Namespace > TdPeriodTimestampWithTimeZone Structure > Subtraction Operator : Subtraction(TdPeriodTimestampWithTimeZone,TdIntervalYearToMonth) Operator
A TdPeriodTimestampWithTimeZone.
A TdIntervalYearToMonth that will be subtracted from a TdPeriodTimestampWithTimeZone.
Subtracts the specified TdIntervalYearToMonth from a TdPeriodTimestampWithTimeZone.
Syntax

Parameters

period
A TdPeriodTimestampWithTimeZone.
interval
A TdIntervalYearToMonth that will be subtracted from a TdPeriodTimestampWithTimeZone.

Return Value

A TdPeriodTimestampWithTimeZone is returned that is the result of subtracting the TdIntervalYearToMonth from a TdPeriodTimestampWithTimeZone.
Exceptions
ExceptionDescription
Unable to subtract the interval from a TdPeriodTimestampWithTimeZone.
The TdPeriodTimestampWithTimeZone beginning bound is greater or equal to the ending bound of the period.
Remarks

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

The interval interval will be subtracted from TdPeriodTimestampWithTimeZone. For example, if the TdPeriodTimestampWithTimeZone is ("2007-10-04 12:50:56-08:00", "2007-11-01 13:23:54-08:00") and the interval is "5-10" (5 years, 10 months) the operation will result in "2001-12-04 12:50:56-08:00", "2002-01-01 13:23:54-08:00").

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
Overload List