17.10 - Result Type and Attributes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1145-171K
Language
English (United States)

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.