'Declaration Public ReadOnly Property Microsecond As Integer
'Usage Dim instance As TdTimestampWithTimeZone Dim value As Integer value = instance.Microsecond
public int Microsecond {get;}
'Declaration Public ReadOnly Property Microsecond As Integer
'Usage Dim instance As TdTimestampWithTimeZone Dim value As Integer value = instance.Microsecond
public int Microsecond {get;}
Exception | Description |
---|---|
TdException | This instance is TdTimestampWithTimeZone.Null. |
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 |
Target Platforms: Windows 8.1, Windows 10, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019