Type Conversion Functions
If you need to convert between data types within a query, you can use type conversion functions. The CData 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 CData Virtuality Server Base Type | JDBC/ODBC |
| Convert x to type, where type is a CData Virtuality Server Base Type | Standard SQL |