Result Type and Attributes

Teradata Vantage™ SQL Functions, Expressions, and Predicates

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

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.