Microsecond Property (TdTimestamp)

The sub-seconds contained in the time component is returned in microseconds.

Syntax

Visual Basic
C#
C++/CLI

'Declaration
 
Public ReadOnly Property Microsecond As Integer

'Usage
 
Dim instance As TdTimestamp
Dim value As Integer
 
value = instance.Microsecond

public int Microsecond {get;}

public:
property int Microsecond {
   int get();
}

Property Value

The sub-second component is returned as an Int32. It will contain up to TdTimestamp.Scale digits.The microsecond component is returned as an Int32.

Exceptions

Exception	Description
TdException	This instance is TdTimestamp.Null.

Remarks

Teradata only supports up to 6 digits in the fractional portion of a second. Therefore, TdTimestamp also support 6 digits in the sub-seconds. This is represented as a Microsecond. One microsecond is equivalent to 10^-6 of a second.

The following are examples of the fraction that is returned for a given timestamp:

Timestamp	Microsecond Property
9999-12-31 23:59:59.999999, scale = 6	999999
2008-02-29 12:45:00.349000, scale = 6	349000
2008-02-29 12:45:00.34900, scale = 5	34900
2008-02-29 12:45:00.3490, scale = 4	3490
2008-02-29 12:45:00.349, scale = 3	349
2010-11-30 20:31:07.020000, scale = 6	20000
2010-11-30 20:31:07.0200, scale = 4	200
2010-10-31 00:10:01.00090, scale = 5	90

Requirements

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

Reference

TdTimestamp Structure
TdTimestamp Members