Character Strings that Use ANSI DateTime Format

Teradata Vantage™ Data Types and Literals

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K
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)