CAST (value-expr AS { } {FIELD field-name }} {DATATYPE }} {{ }} {{TEXT [CHARACTER_SET IS name] [SIZE IS digits] [CHARACTERS] }} {{ [OCTETS ] }} {{ }} {{VARYING STRING [CHARACTER_SET IS name [SIZE IS digits] [CHARACTERS]}} {{ [OCTETS ]}} {{ }} {{DATE [VMS ] }} {{ [ANSI] }} {{ }} ) {{TIME [SCALE scale-value] }} {{TIMESTAMP [SCALE scale-value] }} {{interval-builtin-expr }} {{F_FLOATING }} {{G_FLOATING }} {{ }} {{ {BYTE } }} {{ {WORD } }} {{[SIGNED] {LONGWORD} [SCALE scale-value] }} {{ {QUADWORD} }} { } interval-builtin-expr {YEAR [SIZE IS digits] [TO MONTH] } {MONTH [SIZE IS digits] } { } { [ ]} { [ { HOUR }]} {DAY [SIZE IS digits] [ TO { MINUTE }]} { [ { SECOND [SCALE scale-value] }]} { [ ]} { } INTERVAL{ [ ] } { [ {MINUTE }] } {HOUR [SIZE IS digits] [ TO {SECOND [SCALE scale-value] }] } { [ ] } { } {MINUTE [SIZE IS digits] [TO SECOND [SCALE scale-value] ] } {SECOND [SIZE IS digits] [SCALE scale-value] } { } Converts a value expression to another data type. RESTRICTION The CAST builtin expression requires a space between the letter T in CAST and the open parenthesis character of the value expression; otherwise, a syntax error occurs.