'Declaration
 
Public Overloads Function Add( _
   ByVal timeSpan As TimeSpan _
) As TdPeriodDate

'Usage
 
Dim instance As TdPeriodDate
Dim timeSpan As TimeSpan
Dim value As TdPeriodDate
 
value = instance.Add(timeSpan)

public TdPeriodDate Add( 
   TimeSpan timeSpan
)

public:
TdPeriodDate Add( 
   TimeSpan timeSpan
) 

Parameters

timeSpan

The TimeSpan that will be added.

Return Value

The only component of the TimeSpan object that will be considered is the day component. When this operation is performed, the day component of the TimeSpan is added to this instance of TdPeriodDate. The day component will be added to both the beginning and ending bounds. For example, if the period is (2007-10-04, 2007-11-01) and TimeSpan is "0.02:00:00.00" (0 days, 2 hours) the add operation will result in a period of (2007-10-04, 2007-11-01).

There is an exception to this behavior. The Advanced SQL Engine contains the reserved word UNTIL_CHANGED. This reserved word can be used as the end bound of a period and signifies that the period goes on forever or "until it is changed." In the SQL Engine, UNTIL_CHANGED is equivalent to the date 9999-12-31 for a period of type date.

When the end bound of a period is UNTIL_CHANGED or 9999-12-31, arithmetic operations performed on this period only affects the beginning bound. This is the behavior of the SQL Engine and the Data Provider.

The following are examples of the result of adding a TimeSpan to a period:

**The number of days will be calculated from the components that were specified when TimeSpan was initialized. Therefore, if a TimeSpan has been initialized as new TimeSpan(47, 60, 20) (47 hours, 60 minutes, 20 seconds), the number of days that will be added to TdPeriodDate will be 2.

Refer to Period Arithmetic for additional information.

Reference

TdPeriodDate Structure
TdPeriodDate Members
Overload List