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



Teradata.Client.Provider Namespace > TdTimeWithTimeZone Structure > Addition Operator : Addition(TdTimeWithTimeZone,TdIntervalDayToSecond) Operator
A TdTimeWithTimeZone.
A TdIntervalDayToSecond that will be added to a TdTimeWithTimeZone.
Adds the specified TdIntervalDayToSecond to 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 added to a TdTimeWithTimeZone.

Return Value

A TdTimeWithTimeZone is returned that is the result of adding a TdIntervalDayToSecond to a TdTimeWithTimeZone.
Remarks

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

The TdIntervalDayToSecond interval will be added to 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, adding 2 hours to "23:54:00+08:00" will result in a TdTimeWithTimeZone value of "01: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 added to the TdTimeWithTimeZone value of "12:50:56.2123:08:00" the operation will result in a TdTimeWithTimeZone value of "23:16:36.8246+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