The result data type, format, and title for CURRENT_TIMESTAMP are:
| Data Type | Format | Title |
|---|---|---|
| TIMESTAMP WITH TIME ZONE | Default format for the TIMESTAMP WITH TIME ZONE data type. For more information on the default formats, see “Data Type Formats and Format Phrases” in Teradata Vantage™ Data Types and Literals, B035-1143. |
Current TimeStamp (fractional_precision) |
To convert CURRENT_TIMESTAMP, use Teradata explicit conversion syntax or ANSI CAST syntax. For an example that uses Teradata explicit conversion syntax to change the default output format, see Example: Changing the Default Output Format.