17.00 - 17.05 - 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.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-30
dita:mapPath
tpt1555966086716.ditamap
dita:ditavalPath
lze1555437562152.ditaval

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.