Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

http://developer.mimer.com


CAST Specification


With the CAST specification it is possible to specify a data type conversion. CAST converts the value of an expression to a specified data type.

CAST Specification Syntax

The syntax for CAST is:

Example

 SELECT CAST(floatcol AS DECIMAL(15,3)),
        CAST(charcol AS VARCHAR(10)),
        CAST(intcol AS CHAR(15)),
        CAST(decimcol AS FLOAT(10))FROM types_tab;

Rules

The following rules apply to CAST:

Standard Compliance

This section summarizes standard compliance for expressions.

Standard
Compliance
Comments
X/Open-95
SQL-92
YES
Fully compliant.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Documentation TOC PREV NEXT INDEX