Send feedback on this topic.
Teradata.Client.Provider
Add(TdIntervalDayToSecond) Method



Teradata.Client.Provider Namespace > TdPeriodTimestamp Structure > Add Method : Add(TdIntervalDayToSecond) Method
The TdIntervalDayToSecond that will be added to this instance of TdPeriodTimestamp.
Adds the specified TdIntervalDayToSecond to this instance of TdPeriodTimestamp.
Syntax
'Declaration
 
Public Overloads Function Add( _
   ByVal interval As TdIntervalDayToSecond _
) As TdPeriodTimestamp
'Usage
 
Dim instance As TdPeriodTimestamp
Dim interval As TdIntervalDayToSecond
Dim value As TdPeriodTimestamp
 
value = instance.Add(interval)

Parameters

interval
The TdIntervalDayToSecond that will be added to this instance of TdPeriodTimestamp.

Return Value

A TdPeriodTimestamp is returned that is the result of adding the TdIntervalDayToSecond to this instance of TdPeriodTimestamp.
Exceptions
ExceptionDescription
Unable to add the specified TdIntervalDayToSecond to this instance of TdPeriodTimestamp.
The TdPeriodTimestamp beginning bound is greater or equal to the ending bound of the period.
Remarks

If interval or this instance of TdPeriodTimestamp is Null a TdPeriodTimestamp.Null will be returned.

The TdIntervalDayToSecond will be added to both the beginning and ending bounds of the period. If the scale between this instance of TdPeriodTimestamp 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 TdPeriodTimestamp.

For example, if the period is "2007-10-04 12:50:56.2123", "2007-11-01 13:23:54.4435") and the interval is "200 20:40:50.654321" (200 days, 20 hours, 40 minutes, 50 seconds and 654321 microseconds), the add operation will result in a period of ("2008-04-22 09:31:46.8666", "2008-05-20 10:04:45.0978").

Requirements

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

See Also

Reference

TdPeriodTimestamp Structure
TdPeriodTimestamp Members
Overload List