Microsecond Property (TdTime)

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 TdTime
Dim value As Integer
 
value = instance.Microsecond

public int Microsecond {get;}

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

Property Value

The microseconds of the time is returned. It will contain up to TdTime.Scale digits.

Exceptions

Exception	Description
TdException	This instance is TdTime.Null.

Remarks

Teradata only supports up to 6 digits in the fractional portion of a second. Therefore, TdTime 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 time:

Time	Microsecond Property
23:59:59.999999, scale = 6	999999
12:45:00.349000, scale = 6	349000
12:45:00.34900, scale = 5	349000
12:45:00.3490, scale = 4	349000
12:45:00.349, scale = 3	349000
20:31:07.020000, scale = 6	20000
20:31:07.0200, scale = 4	200000
00:10:01.00090, scale = 5	900

Requirements

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

Reference

TdTime Structure
TdTime Members