Type Conversion Functions
You are looking at an older version of the documentation. The latest version is found here.
If you need to convert between data types within a query, you can use type conversion functions. The Data Virtuality Server includes two such functions, which are identical but slightly differ in syntax - so the choice between them depends on your syntax.
Function | Definition | Syntax |
---|---|---|
| Convert x to type, where type is a Data Virtuality Server Base Type | JDBC/ODBC |
| Convert x to type, where type is a Data Virtuality Server Base Type | Standard SQL |