Microsecond Property (TdTimeWithTimeZone)

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

public int Microsecond {get;}

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

Property Value

The number of Microseconds is returned as an Int32.

Exceptions

Exception	Description
TdException	This instance is TdTimeWithTimeZone.Null.

Remarks

Teradata only supports up to 6 digits in the fractional portion of a second. Therefore, TdTimeWithTimeZone 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+00:00, scale = 6	999999
12:45:00.349000-08:00, scale = 6	349000
12:45:00.34900-08:00, scale = 5	349000
12:45:00.3490-08:00, scale = 4	349000
12:45:00.349-08:00, scale = 3	349000
20:31:07.020000-01:30, scale = 6	20000
20:31:07.0200-01:30, scale = 4	200000
00:10:01.00090-01:30, scale = 5	900

Requirements

Product	Versions	Platforms
.NET	6, 7	Windows, Linux, MacOS
.NET Framework	4.6.2, 4.7, 4.7.1, 4.7.2, 4.8	Windows
.NET Standard	2.0	Windows, Linux, MacOS

Reference

TdTimeWithTimeZone Structure
TdTimeWithTimeZone Members