Microsecond Property (TdTimestampWithTimeZone)

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 TdTimestampWithTimeZone
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 TdTimestampWithTimeZone.Scale digits.

Exceptions

Exception	Description
TdException	This instance is TdTimestampWithTimeZone.Null.

Remarks

Teradata only supports up to 6 digits in the fractional portion of a second. Therefore, TdTimestampWithTimeZone 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 Microsecond that is returned for a given timestamp:

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

Requirements

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

Reference

TdTimestampWithTimeZone Structure
TdTimestampWithTimeZone Members