Returns the value of an expression converted to a supplied data type.
The CAST, CONVERT, HEXTOINT, and INTTOHEX functions can be used to convert to and from hexadecimal values. For more information on using these functions, see Converting to and from hexadecimal values.
CAST( expression AS datatype )
expression The expression to be converted.
data type The target data type.
The specified data type.
If you do not indicate a length for character string types, the database server chooses an appropriate length. If neither precision nor scale is specified for a DECIMAL conversion, the database server selects appropriate values.
If you use the CAST function to truncate strings, the string_rtruncation database option must be set to OFF; otherwise, there will be an error. It is recommended that you use the LEFT function to truncate strings.
SQL/2003 Core feature.
The following function ensures a string is used as a date:
SELECT CAST( '2000-10-31' AS DATE ); |
The value of the expression 1 + 2
is calculated, and the result is then cast into a single-character string.
SELECT CAST( 1 + 2 AS CHAR ); |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |