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

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