CAST

Purpose

Converts an expression into the specified data type. If this is not possible, then an exception is thrown.

Syntax

cast::=

Cast

Usage Notes

Examples

SELECT CAST('ABC' AS CHAR(15)) STRINGCAST;
SELECT CAST('2006-01-01' AS DATE) DATECAST;