Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Data Types

Domains Next Page

Data type conversions

Type conversions can happen automatically, or they can be explicitly requested using the CAST or CONVERT function. The following functions can also be used to force type conversions :

The following list is a high-level view of autmatic data type conversions:

There are certain cases where the automatic database conversions are not appropriate. For example, the automatic data type conversion fails in the example below.

'12/31/90' + 5
'a' > 0
See also

Comparisons between data types
Converting NCHAR to CHAR
Converting NULL constants to NUMERIC and string types
Converting dates to strings
Converting bit arrays
Converting between numeric sets
Ambiguous string to date conversions