Send feedback on this topic.
Teradata.Client.Provider
Subtraction(TdTimestamp,TdIntervalDayToSecond) Operator



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

Parameters

timestamp
A TdTimestamp.
interval
A TdIntervalDayToSecond that will be subtracted from TdTimestamp.

Return Value

A TdTimestamp is returned that is the result of subtracting the TdIntervalDayToSecond from a TdTimestamp.
Exceptions
ExceptionDescription
Unable to subtract the specified TdIntervalDayToSecond from the TdTimestamp.
Remarks

If either parameter is Null a TdTimestamp.Null will be returned.

The TdIntervalDayToSecond interval will be subtracted from a TdTimestamp.

If the scale between the timestamp 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 TdTimestamp. For example, if the TdIntervalDayToSecond value of "222 10:25:40.61234" (222 days, 10 hours, 25 minutes and 40.61234 seconds) is subtracted from the TdTimestamp value of "2008-10-10 12:50:56.2123" the operation will result in a TdTimestamp value of "2008-03-02 02:25:15" with 599900 microseconds.

Requirements

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

See Also

Reference

TdTimestamp Structure
TdTimestamp Members
Overload List