CDO$HELP.HLB  —  Expressions  value_expr, Parameters  cast-builtin-expr
    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.
Close Help