Implicit Type Conversions - 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

There are types for which Vantage permits assignment and comparison without requiring the types to be explicitly converted.

Database Engine 20 performs implicit type conversions in the following cases:
  • On argument types passed to macros, stored procedures, and SQL functions such as SQRT (but there are exceptions).
  • On the expression that defines a time zone displacement in an AT clause.