Data type conversion functions convert arguments from one data type to another.
This table lists the data type conversion functions and their parameters.
Data type conversion function |
Parameters |
|---|---|
BIGINTTOHEX |
( integer-expression ) |
CAST |
( expression AS data type ) |
CONVERT |
( data type, expression [ , format-style ] ) |
HEXTOBIGINT |
( hexadecimal-string ) |
HEXTOINT |
( hexadecimal-string ) |
INTTOHEX |
( integer-expr ) |
ISDATE |
( string ) |
ISNUMERIC |
( string ) |