Valid tosql Transform Functionality - Teradata Vantage - Analytics Database

SQL Data Definition Language Detailed Topics
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-22
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
jbg1472252759029
lifecycle
latest
Product Category
Teradata Vantage™

The following table documents the valid inputs for tosql functionality.

Source Input Source Data Type of Routine Definition Target Data Type of Routine Definition Target Output
  • BYTEINT
  • SMALLINT
  • INTEGER
  • BIGINT
  • DECIMAL
  • NUMERIC
  • REAL
  • FLOAT
  • DOUBLE PRECISION
  • DATE
  • CHARACTER
  • VARCHAR
 BYTEINT UDT UDT
SMALLINT
INTEGER
BIGINT
DECIMAL
NUMERIC
REAL
FLOAT
DOUBLE PRECISION
  • BYTE
  • VARBYTE
  • BLOB
 BYTE
VARBYTE
BLOB
  • CHARACTER
  • VARCHAR
  • CLOB
  • BYTEINT
  • SMALLINT
  • INTEGER
  • BIGINT
  • DECIMAL
  • NUMERIC
  • REAL
  • FLOAT
  • DOUBLE PRECISION
  • DATE
 CHARACTER
VARCHAR
CHARACTER VARYING
  • CHARACTER
  • VARCHAR
  • CLOB
 CLOB
  • DATE
  • BYTEINT
  • SMALLINT
  • INTEGER
  • BIGINT
  • DECIMAL
  • NUMERIC
  • REAL
  • FLOAT
  • DOUBLE PRECISION
  • CHARACTER
  • VARCHAR
 DATE UDT UDT
  • TIME
  • TIME WITH TIME ZONE
  • CHARACTER
  • VARCHAR
 TIME
TIME WITH TIME ZONE
TIMESTAMP
TIMESTAMP WITH TIME ZONE
  • INTERVAL YEAR
  • INTERVAL YEAR TO MONTH
  • INTERVAL MONTH
 INTERVAL YEAR
INTERVAL YEAR TO MONTH
INTERVAL MONTH
  • INTERVAL DAY
  • INTERVAL DAY TO HOUR
  • INTERVAL DAY TO MINUTE
  • INTERVAL DAY TO SECOND
  • INTERVAL HOUR
  • INTERVAL HOUR TO MINUTE
  • INTERVAL HOUR TO SECOND
  • INTERVAL MINUTE
  • INTERVAL MINUTE TO SECOND
  • INTERVAL SECOND
 INTERVAL DAY
INTERVAL DAY TO HOUR
INTERVAL DAY TO MINUTE
INTERVAL DAY TO SECOND
INTERVAL HOUR
INTERVAL HOUR TO MINUTE
INTERVAL HOUR TO SECOND
INTERVAL MINUTE
INTERVAL MINUTE TO SECOND
INTERVAL SECOND