Supported Data Types with Implicit Conversions | VantageCloud Lake - Implicitly Convertible Data Types - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530

Database Engine 20 performs implicit conversion on the following types:

From Byte to:
  • Byte

    Byte types include BYTE, VARBYTE, and BLOB.

From Numeric to:
  • Numeric
  • DATE
  • Character
From DATE to:
  • Numeric
  • DATE
  • Character
From Character to:
  • Numeric
  • DATE
  • Character

    Character types include CHAR, VARCHAR, and CLOB.

  • Period
  • TIME
  • TIMESTAMP