'Usage Dim instance As TdTimestamp Dim format As String Dim value As String value = instance.ToString(format)
Parameters
- format
- The DateTime format string that will be used to format the TdTimestamp.
'Usage Dim instance As TdTimestamp Dim format As String Dim value As String value = instance.ToString(format)
Exception | Description |
---|---|
System.FormatException | The specified format specifier is not supported. |
If the format parameter is null, the format of the string representation of the timestamp will be "yyyy-MM-dd HH:mm:ss.ffffff.
The format specifiers that will be supported are as follows:
Format Specifier | Description |
---|---|
d | The short date pattern. "MM/dd/yyyy". |
D | The long date pattern. "dddd, dd MMMM". |
f | The long date and short time patterns. |
F | The long date and long time patterns. |
g | The short date and short time patterns. |
G |
The ANSI representation of the timestamp. "yyyy-MM-dd HH:mm:ss.ffffff". The number of digits in the fractional seconds will depend upon the Scale of the timestamp. Cultural information is ignored in this conversion. The number of digits that will appear in the fractional seconds is dependent on the TdTimestamp.Scale. For example, if the Scale is set to 4, four digits will appear in the fraction. |
H | The short date and long time patterns. |
l or L | The Teradata literal representation of Timestamp. |
m or M | The month and day patterns --"MMMM dd" |
r or R | Converts the TdTimestamp to a string with the format "ddd, dd MMM yyyy HH:mm:ss GMT". Example: Tue, 30 Oct 2007 18:30:20 GMT |
s | The sortable time pattern --"yyyy'-'MM'-'dd'T'HH':'mm':'ss". |
t | The short time pattern --"h:mm tt" |
T | The long time patterm --"h:mm:ss tt" |
u | Converts the TdTimestamp to a string with the format "yyyy-MM-dd HH:mm:ssZ". Example: 2007-10-30 18:30:20Z |
y or Y | The year and month pattern --"h:MMMM, yyyy". |
For additional information about the supported format specifiers refer to Globalization.DateTimeFormatInfo contained in the MSDN documentation.
Target Platforms: Windows 8.1, Windows 10, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019