Type conversion functions
Within your queries, you can convert between datatypes using the CONVERT or CAST keyword. For more information, see Type conversions
Function | Definition |
---|---|
CONVERT(x, type) |
Convert x to type, where type is a Teiid Base Type |
CAST(x AS type) |
Convert x to type, where type is a Teiid Base Type |
These functions are identical other than syntax; CAST is the standard SQL syntax, CONVERT is the standard JDBC/ODBC syntax.
Important
|
Options that are specified on the type, such as length, precision, scale, etc., are effectively ignored - the runtime is simply converting from one object type to another. |