Required Syntax Elements for TD_ConvertTo - Analytics Database

Database Analytic Functions
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantage™
ON clause
Accept the InputTable clause.
TargetColumns
Specify the names of the InputTable columns to convert to another data type.
TargetDataType
Specify either a single target data type for all target columns or a target data type for each target column. If you specify multiple target data types, the function assigns the nth target data type to the nth target column.
Allowed Values for the TargetDataType Element Output Data Type
BYTEINT BYTEINT
SMALLINT SMALLINT
INTEGER INTEGER
BIGINT BIGINT
REAL REAL
DECIMAL DECIMAL (total_digits, precision) where you can specify the values up to 38 and 19 for the total_digits and precision parameters.
VARCHAR Depends on input data type:
  • Input Data Type: VARCHAR
    • Output Data Type: VARCHAR with same CHARLEN, CHARACTER SET, and CASESPECIFIC values as input data type.
  • Input Data Type: CHAR
    • Output Data Type: VARCHAR(32000) with same CHARACTER SET and CASESPECIFIC values as input data type.
  • Input Data Type: CLOB
    • Output Data Type: VARCHAR(32000) with same CHARACTER SET as input data type, NOT CASESPECIFIC.
  • Input Data Type: Other
    • Output Data Type: VARCHAR(32000), CHARACTER SET UNICODE, NOT CASESPECIFIC.
VARCHAR(charlen=len,charset={LATIN | UNICODE} ,casespecific={YES | NO}) VARCHAR(len) with CHARACTER SET charset value, CASESPECIFIC case-specific value.
CHAR Depends on input data type:
  • Input Data Type: CHAR
    • Output Data Type: CHAR with same CHARLEN, CHARACTER SET, and CASESPECIFIC values as input data type.
  • Input Data Type: VARCHAR
    • Output Data Type: CHAR(32000) with same CHARACTER SET and CASESPECIFIC values as input data type.
  • Input Data Type: CLOB
    • Output Data Type: CHAR(32000) with same CHARACTER SET as input data type, NOT CASESPECIFIC.
  • Input Data Type: Other
    • Output Data Type: CHAR(32000), CHARACTER SET UNICODE, NOT CASESPECIFIC.
CHAR(charlen=len,charset={LATIN | UNICODE} ,casespecific={YES | NO}) CHAR(len) with CHARACTER SET charset value, CASESPECIFIC case-specific value.
DATE DATE FORMAT 'YYYY/MM/DD'
TIME TIME(6)
TIMESTAMP TIMESTAMP(6)
TIME WITH ZONE TIME(6) WITH ZONE
TIMESTAMP WITH ZONE TIMESTAMP(6) WITH ZONE
INTERVAL YEAR INTERVAL YEAR(4)
INTERVAL MONTH INTERVAL MONTH(4)
INTERVAL DAY INTERVAL DAY(4)
INTERVAL HOUR INTERVAL HOUR(4)
INTERVAL MINUTE INTERVAL MINUTE(4)
INTERVAL SECOND INTERVAL SECOND(4,6)
INTERVAL YEAR TO MONTH INTERVAL YEAR(4) TO MONTH
INTERVAL DAY TO HOUR INTERVAL DAY(4) TO HOUR
INTERVAL DAY TO MINUTE INTERVAL DAY(4) TO MINUTE
INTERVAL DAY TO SECOND INTERVAL DAY(4) TO SECOND(6)
INTERVAL HOUR TO MINUTE INTERVAL HOUR(4) TO MINUTE
INTERVAL HOUR TO SECOND INTERVAL HOUR(4) TO SECOND(6)
INTERVAL MINUTE TO SECOND INTERVAL MINUTE(4) TO SECOND(6)
CLOB Depends on input data type:
  • Input Data Type: CLOB
    • Output Data Type: CLOB with same CHARLEN and CHARACTER SET value as input data type.
  • Input Data Type: VARCHAR or CHAR
    • Output Data Type: CLOB(1048544000) with same CHARACTER SET as input data type.
  • Input Data Type: Other
    • CLOB(1048544000), CHARACTER SET UNICODE.
CLOB(charlen=len,charset={LATIN | UNICODE})
CLOB LATIN/UTF16 is only supported on the Block File System on the primary cluster. It is not available for the Object File System.
 CLOB(len) with CHARACTER SET charset value.
BYTE BYTE(32000)
BYTE(charlen=len) BYTE(len)
VARBYTE VARBYTE(32000)
VARBYTE(charlen=len) VARBYTE(len)
BLOB BLOB(2097088000)
BLOB(charlen=len) BLOB(len)
JSON JSON(32000), CHARACTER SET UNICODE.
XML XML(2097088000) INLINE LENGTH 4046