SQL Data Types
SQL data types define the type of data to be stored, such as character strings, numbers, and dates.
Character Data Types
Use character data types for storing strings of letters, numbers and symbols.
Numeric Data Types
Use numeric data types for storing numerical data.
Binary Data Types
Use binary data types for storing raw binary data, such as pictures, in a hexadecimal-like notation, up to a length of (32K – 1) bytes.
Bit Data Type
Use the BIT data type for storing Boolean values.
Date and Time Data Types
Use date and time data types for storing dates and times.
Domains
Domains are aliases for built-in data types, including precision and scale values where applicable.
Data Type Conversions
Type conversions happen automatically, or you can explicitly request them using the CAST or CONVERT function.
Compatibility of String to Datetime Conversions
There are some differences in behavior between SAP Sybase IQ and Adaptive Server when converting strings to date and time data types.
Created December 19, 2013. Send feedback on this help topic to Technical Publications:
pubs@sap.com