17.10 - Character Strings that Use ANSI DateTime Format - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)
Here is a list of valid character string representations when the implicit or explicit character-to-period conversion uses the ANSI DateTime format to interpret the beginning and ending bound elements.
  • '(''beginning_element_value ''''ending_element_value '')'
  • '(beginning_element_value , Δending_element_value )'
  • '(''beginning_element_value '', Δending_element_value )'
  • '(beginning_element_value , Δ''ending_element_value '')'

where formats of beginning_element_value and ending_element_value depend on the target data type.

Target Data Type Format
PERIOD(DATE) YYYY-MM-DD
PERIOD(TIME[(n)]) HH:MI:SS.S(F)
PERIOD(TIMESTAMP[(n)]) YYYY-MM-DDBHH:MI:SS.S(F)