Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


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.

Syntax for CAST:

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:


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