Type Conversion Functions
You can use type conversion functions if you need to convert between data types within a query. The Data Virtuality Server includes two such functions, which are essentially identical, but slightly differ in the syntax - so the choice between them depends on the syntax you are using.
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 |