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

TdPeriodTimestamp Structure
TdPeriodTimestamp Members
Overload List