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



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

Parameters

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

Return Value

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

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

The TdIntervalDayToSecond interval will be subtracted from a TdTimestampWithTimeZone.

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 TdTimestampWithTimeZone. 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 TdTimestampWithTimeZone value of "2008-10-10 12:50:56.2123+08:00" the operation will result in a TdTimestampWithTimeZone value of "2008-03-02 02:25:15.5999+08:00".

Requirements

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

See Also

Reference

TdTimestampWithTimeZone Structure
TdTimestampWithTimeZone Members
Overload List