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, type)

Convert x to type, where type is a Data Virtuality Server Base Type

JDBC/ODBC

CAST(x AS type)

Convert x to type, where type is a Data Virtuality Server Base Type

Standard SQL