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



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

Parameters

time
A TdTimeWithTimeZone.
interval
A TdIntervalDayToSecond that will be subtracted from a TdTimeWithTimeZone.

Return Value

A TdTimeWithTimeZone is returned that is the result of subtracting a TdIntervalDayToSecond from a TdTimeWithTimeZone.
Remarks

If interval or time is Null a TdTimeWithTimeZone.Null will be returned.

The TdIntervalDayToSecond interval will be subtracted from a TdTimeWithTimeZone.

The TdIntervalDayToSecond interval may contain data about the number of days, hours, minutes, seconds, and sub-seconds. The days will be discarded during all calculations. If the time rolls into the next or previous day, the result will only contain the time component. For example, subtracting 2 hours from "01:54:00-08:00" will result in a TdTimeWithTimeZone value of "23:54:00-08:00".

If the scale between the time parameter and the interval parameter are different, the arithmetic operation will be performed using the different scales. The result will then be truncated to match the scale of the TdTimeWithTimeZone. 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 TdTimeWithTimeZone value of "12:50:56.2123:08:00" the operation will result in a TdTimeWithTimeZone value of "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

TdTimeWithTimeZone Structure
TdTimeWithTimeZone Members
Overload List