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



Teradata.Client.Provider Namespace > TdPeriodTimestamp Structure > Subtraction Operator : Subtraction(TdPeriodTimestamp,TdIntervalYearToMonth) Operator
A TdPeriodTimestamp.
A TdIntervalYearToMonth that will be subtracted from a TdPeriodTimestamp.
Subtracts the specified TdIntervalYearToMonth from a TdPeriodTimestamp.
Syntax
'Declaration
 
Overloads Public Operator -( _
   ByVal period As TdPeriodTimestamp, _
   ByVal interval As TdIntervalYearToMonth _
) As TdPeriodTimestamp
'Usage
 

Parameters

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

Return Value

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

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

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

Requirements

Target Platforms: Windows 8.1, Windows 10, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019

See Also

Reference

TdPeriodTimestamp Structure
TdPeriodTimestamp Members
Overload List