Skip to main content
Skip table of contents

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, 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
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.