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



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

Parameters

interval
The TdIntervalDayToSecond that will be added to the period.

Return Value

A TdPeriodTimeWithTimeZone is returned that is the result of adding the TdIntervalDayToSecond to this instance of TdPeriodTimeWithTimeZone.
Exceptions
ExceptionDescription
Unable to add the specified TdIntervalDayToSecond to this instance of TdPeriodTimeWithTimeZone.
Remarks

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

When this operation is performed, the day component of the interval is ignored. Only the hour, minute, and second components are used in this operation. For example, if the period is "01:00:00-08:00, 01:30:00-08:00" and the interval is "1 02:00:00.00" (1 day, 2 hours) the add operation will result in a period of (03:00:00-08:00, 03:30:00-08:00).

When adding an interval to a TdPeriodTimeWithTimeZone it is possible that the ending bound will roll into the next 24 hours, or the beginning bound will roll into the previous 24 hours. For example, suppose the period is

   (19:32:32.3404-08:00, 22:00:00.3232-08:00)

Adding the interval of "0 03:00:00" (3 hours) to the period will cause the ending bound to roll into the next 24 hours which will result in the invalid period:

    (22:32:32.3404-08:00, 01:00:00.3232-08:00)

Adding the interval of "-0 20:00:00" (-20 hours) to the same period will cause the beginning period to roll back into the previous 24 hours which results in the invalid period:

    (23:32:32.3404-08:00, 02:00:00.3232-08:00)
Requirements
ProductVersionsPlatforms
.NET2.1, 3.1, 6Windows, Linux, MacOS
.NET Framework4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8Windows
.NET Standard2.0Windows, Linux, MacOS
See Also

Reference

TdPeriodTimeWithTimeZone Structure
TdPeriodTimeWithTimeZone Members
Overload List