Skip to main content
Skip table of contents

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, 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.