Send feedback on this topic.
Teradata.Client.Provider
Addition(TdTimestamp,TimeSpan) Operator



Teradata.Client.Provider Namespace > TdTimestamp Structure > Addition Operator : Addition(TdTimestamp,TimeSpan) Operator
A TdTimestamp.
A TimeSpan that will be added to TdTimestamp.
Adds the specified TimeSpan to a TdTimestamp.
Syntax
'Declaration
 
Overloads Public Operator +( _
   ByVal timestamp As TdTimestamp, _
   ByVal span As TimeSpan _
) As TdTimestamp
'Usage
 
public TdTimestamp operator +( 
   TdTimestamp timestamp,
   TimeSpan span
)
public:
TdTimestamp operator +( 
   TdTimestamp timestamp,
   TimeSpan span
)

Parameters

timestamp
A TdTimestamp.
span
A TimeSpan that will be added to TdTimestamp.

Return Value

A TdTimestamp is returned that is the result of adding the Timespan to TdTimestamp.
Exceptions
ExceptionDescription
Unable to add the specified TimeSpan to the the TdTimestamp.
Remarks
If span is Null a TdTimestamp.Null will be returned.

If the scale between the timestamp and the span parameters are different the arithmetic operation will be performed using the different scales. The result will then be truncated to match the scale of the timestamp. For example, the addition operation

TdTimestamp.Parse("2008-10-10 12:48:53.2123") + TimeSpan.Parse("00:02:03.000099")

results in a TdTimestamp value of "2008-10-10 12:50:56.2123".

A TimeSpan can have a scale up to 7. A TdTimestamp has a maximum scale of 6. When performing an arithmetic operation, only the first 6 digits to the right of the decimal point of the TimeSpan operand will be considered. The 7th digit will be ignored.

Requirements

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

See Also

Reference

TdTimestamp Structure
TdTimestamp Members
Overload List